Dell-EMC
E20-885 · Question #103
E20-885 Question #103: Real Exam Question with Answer & Explanation
The correct answer is A. Increase the number of spindles servicing this database.. See the full explanation below for the reasoning.
Question
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?
Options
- AIncrease the number of spindles servicing this database.
- BUse SQL Activity Monitor to identify rogue queries that may be affecting performance.
- CMigrate the database to lower latency spindles.
- DDecrease the queue length setting on the HBA.
Community Discussion
No community discussion yet for this question.