Dell-EMC
E20-816 · Question #48
A data warehouse team is reporting poor performance on their batch reports. The database runs on a Solaris host connected to a DMX-4 array with Fibre Channel drives sized to support a sequential…
The correct answer is B. Prefetched tracks per second vs. Tracks not used per second. See the full explanation below for the reasoning.
Question
A data warehouse team is reporting poor performance on their batch reports. The database runs on a Solaris host connected to a DMX-4 array with Fibre Channel drives sized to support a sequential read workload. Which ratio in Performance Manager metrics would be most useful in diagnosing the performance issue?
Options
- ARead % vs. Write %
- BPrefetched tracks per second vs. Tracks not used per second
- CKBytes read per second vs. I/O per second
- DI/O per second vs. Average sampled read time
How the community answered
(27 responses)- A7% (2)
- B85% (23)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.