Explanation:The coordinator thread in a parallel query always accumulates these waits. 3. How many types of wait occur in SQL Server ?
A. 2
B. 3
C. 4
D. 5
Answer:A
Explanation:The coordinator thread in a parallel query always accumulates these waits. 3. How many types of wait occur in SQL Server ?
A. 2 B. 3 C. 4 D. 5
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: