Provisioning SQL Databases — Question 21

You have Microsoft SQL server on a Microsoft Azure virtual machine. The virtual machine has 200 GB of data.
User report a slow response time when querying the database.
You need to identify whether the storage subsystem causes the performance issue.
Which performance monitor counter should you view?

Answer options

• A. Data sec/Write
• B. Avg.disk Read Queue Length
• C. % Disk Read Time
• D. Disk sec/Read

Correct answer: B

Explanation

The correct answer is B, Avg.disk Read Queue Length, as it indicates the number of requests waiting to be processed by the disk. A high queue length can suggest that the storage subsystem is a bottleneck. The other options measure different aspects of disk performance, but they do not specifically identify the queuing issue related to read requests.