You performed an analysis of the I/O profile of a SQL Server environment that has performance
and availability issues. Having identified disk contention as the primary problem, what would be
your recommendation?

A.
Allocate additional spindles and migrate the transaction logs to the new RAID group

B.
Enable SQL Server to keep pages in memory

C.
Enable fast file initialization

D.
Move SQL transaction log and database files to the same RAID/disk group