Post reply

How to reset performance data on reports?

  • March 7, 2007 at 11:39 am

    #172627

    I'm looking for a way to reset performance statistics data on the summary / reports view for servers (like object execution statistics) on management studio (other than restarting the service, I need to do it while the db is online)

    I've modified some stored procedures. I need to reset the performance statistics, so I'll be able to see the totals for all procedures in the same time period with right percentages.

  • March 7, 2007 at 12:09 pm

    #693639

    Hello,

    If you want to clear of the Buffer Pool to check up the execution time, then you need to use DBCC FREEPROCCACHE. The execution times might differ as it has to read the data from the disk when you execute the first time. The next time when you execute the same it will pull out the execution plan from the Buufer Pool.

    Hope this helps you.

    Thanks

     


    Lucky

  • March 23, 2007 at 8:03 pm

    #696734

    Thanks Lucky! Though it's not the best thing to do on a production server, it simply works for me and does what I need =)

    I've also found this one recently:

    DBCC SQLPERF ('sys.dm_os_latch_stats', CLEAR);

    DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR);

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

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