how to find the top 10 Time consuming stored procedures in sql server 2000?

• suri1984

  SSC-Addicted

  Points: 463

  More actions

  August 1, 2008 at 10:36 am

  #382111

  HI,

  Is there any script to find the top 10 Time consuming stored procedures in sql server 2000?

  Thx

• Wildcat

  SSCarpal Tunnel

  Points: 4774

  More actions

  August 1, 2008 at 11:54 am

  #852074

  In 2000, you need to have a trace, then, get this info.:unsure: