stored procedure taking more time

• sachinrshetty

  SSCrazy

  Points: 2062

  More actions

  June 8, 2010 at 6:01 am

  #225367

  Hi,

  I have stored procedure where in i have used cursor, while loops. It takes lot of time some 2.5 mins for complete execution.

  So, how do i find which part is taking more time so that i can fix it. Is there any technique or tools to find the time consumed for different sql queries within that procedure.

  Sachin

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 8, 2010 at 6:06 am

  #1177412

  Have a look at these articles

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• sachinrshetty

  SSCrazy

  Points: 2062

  More actions

  June 8, 2010 at 6:09 am

  #1177415

  Thank u man. I will check with those links and revert you