Our business intends to acquire a storage-area network (SAN) this year as we want to move away from direct-attached storage (DAS). Fifty percent of our data is in a business-critical SQL database and Microsoft Exchange Server, while the other 50% consists of Microsoft Office documents. What RAID configurations should we consider for our new SAN and why?
A multiple disk tray approach is needed in this situation. You do not want to put the Office files on the fastest and most expensive disks, however the SQL data does require high performance. A fast
disk tray configured as
will give the best SQL performance, while a secondary disk tray with
drives configured as
will give resilience at a much reduced cost.
With some storage-area networks it is possible to move data between these drive sets using an automated data tiering function based on user-defined file access rules. You may also be able to pin data by volume into specific disk areas so you could, for example, use the fastest disk tray for the SQL data. RAID 10 uses a stripe and mirror approach that is fast and resilient. RAID 5 stripes disks with parity providing resilience against disk failure with a one to three disk overhead.
For more information, read "RAID levels explained"