Cause of Poor Performance in SQL Server

Troubleshooting a SQL Server performance problem is often a frustrating exercise as, without some experience in tuning, it's hard to know where to start and what to do. In this article, part 1 of a 2-part series, I'm going to walk through a hypothetical scenario that takes a badly-performing database and demonstrates how to find the problematic procedures, and the problematic queries within them, using SQL Profiler. Please refer this link to get cause of poor performance in SQL server.

Continue here >