Dell-EMC
E20-322 · Question #198
You performed an analysis of the I/O profile of an SQL Server environment that has performance and availability issues. Having identified disk contention as the primary problem, what would be your…
The correct answer is B. Enable another instance of SQL server to spread the workloads. See the full explanation below for the reasoning.
Question
You performed an analysis of the I/O profile of an SQL Server environment that has performance and availability issues. Having identified disk contention as the primary problem, what would be your recommendation?
Options
- AAllocate additional spindles and migrate the transaction logs to a separate RAID group.
- BEnable another instance of SQL server to spread the workloads.
- CEnable fast file initialization.
- DMove SQL transaction log and database files to the same RAID group.
How the community answered
(30 responses)- A3% (1)
- B83% (25)
- C10% (3)
- D3% (1)
Community Discussion
No community discussion yet for this question.