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?

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



Leave a Reply 0

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