Dell-EMC
E20-818 · Question #37
A customer's SQL database has been experiencing performance degradation every time a particular query is run. When designing the storage layout, all user databases were properly sized according to…
The correct answer is A. Tempdb and user databases are sharing spindles. See the full explanation below for the reasoning.
Question
A customer's SQL database has been experiencing performance degradation every time a particular query is run. When designing the storage layout, all user databases were properly sized according to EMC best practices. Which storage configuration could be the source of the problem?
Options
- ATempdb and user databases are sharing spindles
- BMDF and LDF files are not sharing spindles
- CRAID 5 protection has been used for Tempdb
- DData files are spread over striped metavolumes
How the community answered
(35 responses)- A77% (27)
- B6% (2)
- C11% (4)
- D6% (2)
Community Discussion
No community discussion yet for this question.