SQL SERVER – Raid Configuration – RAID 10

I get question about what configuration of redundant array of inexpensive disks (RAID) I use for my SQL Servers.

The answer is short is: RAID 10. Why? Excellent performance with Read and Write.

RAID 10 has advantage of both RAID 0 and RAID 1. RAID 10 uses all the drives in the array to gain higher I/O rates so more drives in the array higher performance. RAID 5 has penalty for write performance because of the parity in check. There are many article already written about them. If you are interested in reading more please refer book online.

Reference : Pinal Dave (http://blog.SQLAuthority.com), BOL

About these ads