SQL Server Performance

How to reset performance data on reports?

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by MrRobot, Mar 7, 2007.

  1. MrRobot New Member

    Hey guys,

    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.
  2. MohammedU New Member

    Are you asking about these...

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

  3. MrRobot New Member

    exactly! I have used "dbcc freespcacheindb" to solve it, but this will be more helpful, preventing recompiles, and potential bad plan usage. Thank you MohammedU!

Share This Page