Post reply

Monitor Sprocs

  • June 2, 2004 at 2:23 am

    #163672

    Hello people!!!

    Is there a way I can monitor how many times a stored procedure was used?

    Hope to hear from you guys...

     

    Regards

     

  • June 2, 2004 at 4:17 am

    #508606

    use sql profiler. use this site for an indepth overview and scripts to do this:

    http://vyaskn.tripod.com/analyzing_profiler_output.htm

     

    andy

  • June 2, 2004 at 7:26 am

    #508652

    Please post in an appropriate forum. This forum (QOD or Question Of The Day) is strictly for discussing the Question of the Day. The QOD is a daily 'test' question that can be found at Resourses>Question of the Day.

    -SQLBill

  • June 3, 2004 at 3:15 am

    #508787

    you have to make a new table that has (date/time, user, Spname)

    and you have to add code to add data of the user executing this procedure into above table ..

    then you can count how many times this SP used

    i hope this help u

     


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

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

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