What is the recommended Hard Drive configuration for Provideam Database Files?
Single Hard Drive - Not Recommended
This is not a recommend option, a) because there is no redundancy in case of hard disk failure, and b) because performance will suffer under heavy usage.
SAN Drive System - Not Recommended
SAN systems are great for file servers and other applications. However for hard drive intensive applications such as databases, SAN Systems will, in many cases, not be the best solution.
Because SAN systems cost a lot money the tendency is to use them in every possible situation. They typically end up being loaded with lots of different types of data.
SQL Server does not like sharing disk space. I/O performance will go down, and add to that other factors such as routers, slow network speed etc.
The result for database systems is usually disappointing performance and a bad cost to performance ratio.
A SAN systems is a good place to store your Database Backups.
Solid State Device(SSD) Hard Drive - Not Recommended
SSDs are interesting and can offer vast speed improvements, but there are physical limitations that in a SQL Server setup can cause issues.
The limited number of write cycles per cell and flash wear-out can be a problem depending on the quality of the drives and the load.
RAID mirroring should always be used with SSD systems.
RAID 10 Hard Drive Configuration - Recommended
Local storage setup in RAID 10 is our recommended option for enterprise level systems. In this setup 4 or more hard disks are used to create a mirrored raid (RAID 1) for redundancy and then a RAID 0 for performance combining the best of both worlds.
This is an excellent comprise between cost and performance.