How to reset performance data on reports? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to reset performance data on reports?

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.
Are you asking about these… DBCC SQLPERF (‘sys.dm_os_latch_stats’, CLEAR);
DBCC SQLPERF (‘sys.dm_os_wait_stats’, CLEAR);
MohammedU.
Moderator
SQL-Server-Performance.com
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!
]]>