Stored Procedure

• Raghavender Chavva

  SSCrazy Eights

  Points: 8669

  More actions

  August 9, 2011 at 6:24 am

  #255127

  Hi All,

  I have a stored procedure, which contains more than 10 queries. and its taking long time to execute.

  How can I find which query is taking long time ?

  Thank You.

  Regards,
  Raghavender Chavva

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 9, 2011 at 6:34 am

  #1365832

  Please save the execution plan and post it here as per : http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  Edit :

  Those are nice too to figure out which procs are generating the most problems.

  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/