Originally Posted by Pete838
For hardware I'm a big fan of RAID 10 with 4 to 6 drives, and always a hardware RAID controller. Never software RAID. Dell makes a H710-P raid controller that can't be beat. For drives I prefer to keep SQL data on 300gb enterprise raid 10 array and documents and seldom accessed data (like reports, backups, etc) on a separate array of 1-2 Tb. For most office stuff a RAID 10 is going to be far more reliable than a consumer SSD, and far more economical than enterprise SSD which will cost more than taking your entire staff on vacation to the Bahamas.


I'm a huge fan of RAID 10, but the IOPS on a RAID 1 with 2 SSD drives would need something like 40 hard drives in RAID 10 to match it. Hardware RAID controllers mainly come into play for parity-based RAID Schemes like RAID 5 and RAID 6 which require significant processing power. RAID 10 HDD for Storage, RAID 1 SSD for database applications.

Also, no one needs enterprise/SLC SSD's. The write endurance people were freaking out about isn't true. It's been debunked. For example, a Samsung 840 Pro (last gen) had a wrtite endurance of 2.1PB (petabytes, 2100 Terabytes). For most practices, a set of pro-sumer SSDs in RAID 1 will work fine. Larger practices may want want too look at different SSDs. These drives have a lower AFR (annual failure rate) than hard drives and 10 Year Warranties on some of them. When was the last time, you saw a 10 year warranty on a computer part?