Home Forums SQL Server 2005 Administering How to find the stored procedure causing performnace problem RE: How to find the stored procedure causing performnace problem
srivathsani-296624
Ten Centuries
Points: 1208
More actions
June 8, 2011 at 4:18 am
#1335517
You can also use sql profiler to find out which sp in your application is taking a lot of time.You can fine tine the performance of that Sp by fine tuning the querie sin that sp with help of sql profiler and execution plans.