Microsoft
70-433 · Question #35
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…
The correct answer is B. CPU. See the full explanation below for the reasoning.
Question
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?
Options
- ADisk
- BCPU
- CMemory
- DNetwork
How the community answered
(57 responses)- A4% (2)
- B79% (45)
- C11% (6)
- D7% (4)
Community Discussion
No community discussion yet for this question.