Dell-EMC
E20-816 · Question #143
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 A. I/O per second, KBytes read per second, prefetched tracks per second, Tracks not used per. 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 metrics in Performance Manager would be useful in diagnosing the performance issue?
Options
- AI/O per second, KBytes read per second, prefetched tracks per second, Tracks not used per
- BAverage sampled read time, KBytes read per second, I/O per second, Read hit %
- CKBytes read per second, Prefetched tracks per second, Read %, Write %
- DRead hit %, Tracks not used per second, Average sampled read time, I/O per second
How the community answered
(36 responses)- A75% (27)
- B14% (5)
- C3% (1)
- D8% (3)
Community Discussion
No community discussion yet for this question.