You notice that a database server is responding slowly to queries. You run the following dynamic
management views (DMV) query on the server. SELECT TOP (10)
wait_type,
wait_time_ms
FROM sys.dm_os_wait_stats
ORDER BY wait_time_ms DESC;
The query returns a top wait type of SOS_SCHEDULER_YIELD.
You need to identify what is causing the server response issues. Which resource should you
investigate
first?
A.
Disk
B.
CPU
C.
Memory
D.
Network