Post reply

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

  • August 1, 2008 at 10:36 am

    #195169

    HI,

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

    Thx

  • August 4, 2008 at 3:09 pm

    #852926

    Hi,

    What about recording trace (http://support.microsoft.com/kb/283790/) with SP:Completed or RPC:Completed events. Later importing trace files into your dev database and quering the result set for long running querier ( ORDER BY Duration DESC ).

    Hope this will help, Max

    Cheers, Max

    Check-out free open-source utility Sql Server Replication Explorer[/url]

  • August 4, 2008 at 8:55 pm

    #852979

    or simple set the duration like: duration > 9999

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply