Sql Server Reset DMVs Counters
- Posted by Sqltimes
- On October 6, 2013
- 0 Comments
Quick one today:
This is something I use, frequently, in our performance lab environment to reset wait & latch stats counters before every volume testing (Performance Testing).
[sourcecode language=”sql”]
DBCC SQLPERF(‘sys.dm_os_wait_stats’,CLEAR)
GO
DBCC SQLPERF(‘sys.dm_os_latch_stats’,CLEAR)
GO
[/sourcecode]
Surprisingly, it does not reset all the DMV’s. Only these two DMV’s. May be this is by design.
Hope this helps,
_Sqltimes
0 Comments