Six months ago, you implemented an SQL 2008 database and followed EMC best practices for
sizing and layout. The database is now experiencing performance slowdowns. You configure
Perfmon to capture “disk bytes per second”, “average disk queue length”, and “percent disk time”

in a log view for the database volumes. The log shows the disk bytes per second remained steady
but there was an increase in the average disk queue length.
Which action should you take to solve this problem?

A.
Increase the number of spindles servicing this database.

B.
Use SQL Activity Monitor to identify rogue queries that may be affecting performance.

C.
Migrate the database to lower latency spindles.

D.
Decrease the queue length setting on the HBA.