PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Disk

B.
CPU

C.
Memory

D.
Network


Leave a Reply