Explanation:SQL Server mainly supports three types of waits:Resource waits,Queue waits and External waits 4. The contents of sys.dm_os_wait_stats can be reset by running 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
Answer:A
Explanation:SQL Server mainly supports three types of waits:Resource waits,Queue waits and External waits 4. The contents of sys.dm_os_wait_stats can be reset by running 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
Explanation:DBCC SQLPERFcommand resets all counters to 0. 5. Point out the wrong statement :