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 >