Post reply

Stored Procedures usage in SQL Server 2000 version

  • January 4, 2012 at 5:17 pm

    #250656

    Hello All:

    I would like to know all the Stored Procedures usage information in a database(for example say execution count of all SPs) in SQL Server 2000 version.

    In SQL versions 2005 and later we use the DMV "sys.dm_exec_query_stats", but not sure how to see this information in earlier versions of SQL.

    Any help is appreciated!

    Thanks,

    Suresh.

  • January 17, 2012 at 3:47 pm

    #1434914

    I would try using server side profiler that will write to a flat file. Once done, you can aggregate the data from the file how ever you want.

    Fraggle

  • January 17, 2012 at 4:56 pm

    #1434922

    The other option in SQL 2000 was to add a line of code to each proc that would write out execution details to a log table.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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