Post reply

Procedure Hit Rate

  • May 13, 2004 at 3:03 am

    #160875

    Is there anything in SQL Server that will provide a report on the hit rate of all procedures? I am looking for a way to monitor which procedures are used the most so I can prioritise performance tuning.

     

    Cheers in advance guys!

  • May 13, 2004 at 3:24 am

    #506260

    In the old day, one can DBCC MEMUSAGE. You have to find the replacement.

  • May 13, 2004 at 5:10 am

    #506274

    Cheers wz700, this has now been replaced by the SQL Buffer and Cache management objects. I accessed these through Performance monitor and created a test report but unfortunately results are pretty limited.

    I think I am going to have to create a simple function I can add to every procedure that will just increment a count for each procedure in an alternative table (Just to gather data for an hour or so).

    Any other suggestions?

  • May 13, 2004 at 7:25 am

    #506301

    Why not use SQL profiler?

    LinkedIn Profile

  • May 14, 2004 at 7:17 am

    #506471

    I added a function to our procedures but have not figured out a way to know what views are used. I would love to know which views were created and then accessed only once.

    Any ideas?

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

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