Question

The contents of sys.dm_os_wait_stats can be reset by running which of the following command?

(a) DBCC PERF (‘sys.dm_os_wait_stats’, CLEAR);

(b) DBCC SQLP (‘sys.dm_os_wait_stats’, CLEAR);

(c) DBCC SQLPERF (‘sys.dm_os_wait_stats’, CLEAR);

(d) None of the mentioned

The question was posed to me in an interview for internship.

Query is from Wait States in section Monitoring and Auditing of SQL Server

Answer 1

Right option is (c) DBCC SQLPERF (‘sys.dm_os_wait_stats’, CLEAR);

Explanation: DBCC SQLPERFcommand resets all counters to 0.