Which resource should you investigate first?

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. Memory
B. Network
C. CPU
D. Disk

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.