Worst performing procedures

• haichells

  SSCrazy

  Points: 2713

  More actions

  July 15, 2010 at 8:19 am

  #146289

  Hi,

  I have a requirement like i need to track the stored procedures which are taking more than 30-45 secs and inform to the concerned team to optimize. Please let me know whether we have any option to get the worst performing list from dmv.

  Thanks in Advance!

• Shanalise

  Hall of Fame

  Points: 3188

  More actions

  July 16, 2010 at 12:33 am

  #1193900

  See this article it might give you some directions

  http://www.codeproject.com/KB/database/Dynamic_Management_Views.aspx

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  July 16, 2010 at 2:33 am

  #1193936

  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