What would be the optimal disk config for SQL Server 2008 R2?
- by Kev
We have a new Dell R710 server that came with the following storage configuration:
8 x 146GB SAS 10k 6Gbps disks
1 x Perc H700 Integrated Controller (2 x 4 disks - 2 ports each supporting 4 disks)
What would be the optimal configuration if we were just after performance?
What would be the optimal configuration if we were after performance but wanted data resilience.
As per 2 above but with a hot standby disk?
We plan to run Windows 2008 R2 and SQL Server 2008 R2.
Maximising storage capacity isn't a prime concern.