SQL SERVER - Raid Configuration - RAID 10 « Journey to SQL Authority with Pinal Dave

Feed on: Posts; Comments

SQL SERVER - Raid Configuration - RAID 10

April 22, 2007 by pinaldave

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: BOL

Posted in Database, Main, Pinal Dave, SQL, SQL Authority, SQL Download, SQL Error Messages, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Server DBCC, SQL Tips and Tricks, T SQL, Technology | 8 Comments

8 Responses to “SQL SERVER - Raid Configuration - RAID 10”

on April 30, 2007 at 9:08 am Alan Saunders

Surely the RAID array described in the ‘Book online’ link above is RAID 0+1 not RAID 10 (1+0)
RAID 0 (striped) Mirrored to another RAID 0 i.e stripe two sets of disks then mirror the stripes

RAID 10 as I understand it is a RAID 0 Array of RAID 1 Mirrored pairs. i.e. Mirror pairs of disks, then stripe the mirrored pairs.

In RAID 0+1, any one drive failing from each RAID-0 array (2 drives) will fail the entire array, whereas any two drives failing in a RAID 1 + 0 array will only fail the entire array if the drives concerned are both halves of the same mirrored pair.

Please tell me if I’m wrong
on April 30, 2007 at 7:44 pm pinaldave

Alan,

It is correct. RAID 10 is RAID 0+1. As we already have RAID 1 and to avoid confusion RAID 0+1 = RAID 01 is called RAID 1+0 = RAID 10.

Your observation about RAID is correct. Thank you,

Pinal Dave
(http://www.SQLAuthority.com)
on August 10, 2007 at 2:15 am Dan Rous

To quote “RAID 10 is RAID 0+1″… sorry but that’s rubbish!
RAID 10 is RAID 1+0!
RAID 01 is RAID 0+1!
So to have said “to avoid confusion RAID 0+1 = RAID 01 is called RAID 1+0 = RAID 10″ is incorrect!?
Surely you’re not claiming that RAID 0+1 is the same as RAID 10?
on January 18, 2008 at 11:27 pm Paul

Sorry Dan but you are incorrect. The industry says that RAID 0+1 is also known as RAID 10. I am 100% certain
on January 23, 2008 at 9:52 pm cheng

I tried to shrink production db it has three files of data. each of them left about 220 MB free space.
database data_1 size 2192 MB, free space 0 MB.
data_2 size 2219 mb, free space 224.6 mb
how can I shrink them?

DBCC shrink database (proDB, ?)
Go
on January 25, 2008 at 11:09 pm Rich

Alan and Dan are correct. Pinaldave and Paul are incorrect. RAID 0+1 is NOT the same as RAID 10. The RAIDs differ because the RAID modes are layered (nested) in the opposite order. RAID 0+1 is vulnerable to single drive failure, as Alan observed correctly. This point is confirmed and reinforced on multiple RAID reference sites.
on February 27, 2008 at 12:44 am Krishnaraj

I agree with Rich.

RAID 01 is a mirrored configuration of two striped sets.
RAID 10 is a stripe across a number of mirrored sets.

Both will combine the Striping and Mirroring But the Difference is which level applied first.
on May 14, 2008 at 9:15 pm subash

Hi, i have been going thru the article on RAID. I found that it is defined as Redundant Array of Inexpensive Disk. While it may sound correct, isn’t the real definition is Redundant Array of Independent Disk?