Explanation:sys.dm_os_wait_stats returns information about all the waits encountered by threads that executed. 2. Point out the correct statement :
A. 510: CXPACKET indicates parallelism
B. SQL Server does not always waits for something, a disk io, a place in the processor queue, a lock
C. Few variations of PAGEIOLATCH waits usually indicate a problem with the disk subsystem
D. All of the mentioned
Answer:A
Explanation:sys.dm_os_wait_stats returns information about all the waits encountered by threads that executed. 2. Point out the correct statement :
A. 510: CXPACKET indicates parallelism B. SQL Server does not always waits for something, a disk io, a place in the processor queue, a lock C. Few variations of PAGEIOLATCH waits usually indicate a problem with the disk subsystem D. All of the mentioned
Explanation:The coordinator thread in a parallel query always accumulates these waits. 3. How many types of wait occur in SQL Server ?