Post reply

A Tool/code Needed

  • September 29, 2004 at 2:09 pm

    #109191

    Hi All,

    I need a tool/code to find out how many times a /all stored procedure(s) have been inoved in a day.

    Appreciate if anyone can help!

    Thanks

    Sneha

  • September 29, 2004 at 3:52 pm

    #524840

    SQL Profiler can do this quite easily.  Start-> SQL Server -> Profiler

    If can look a bit daunting at first but it isn't so bad once you play with it for a bit.

    To get the stats you will have to run it for 24 hours so you should reduce the culumns and events to the bare minimum. Saving the results to a table will make it easier to analyse but use a seperate database with the size limit set so you don't fill the disk.

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

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