Friday, March 26, 2010

Raid setup comparison - Part 1/2

(RAID 5 vs RAID 1E vs RAID 10 )

Every-time, as a consultant DBA, a customer ask me the question which RAID and why will fit best their needs. I tend to provide my experiences, my ideas and share but rarely it's enough.

In this blog entry I will try show exactly for one specific machine what will be the efficiency for each and individual RAID setup in terms of rough IO/S and MB/s.

Note that the tool that I have used is SQLIO, in a near future I plan to also re-do the tests with the tool Iometer. What is important to know is that the situation when I did the tests was ideal. The Raid Setup had been done then re-done according to the needs and there were no application and no user connected to the server during the tests.

The server used is a IBM x336 series with 16GB of RAM, windows 2003 x64 installed. The setup raid was local to the machine, the cache controller was integrated to the machine and its size was 256MB.

Following is the legend table to help you to interpret the different test cases scenario therefore will you find all the detail of each scenario that has been tested :

Test Casethreads#Block Size (KB)Out. RequestDuration
T12641120 seconds
T22642120 seconds
T32644120 seconds
T42648120 seconds
T526416120 seconds
T626432120 seconds
T726464120 seconds
T8264128120 seconds

A. Result extracted for write performance :

  • Table Presentation

1RAID5 - 4HD;145G;15k -MB/S19.0621.8125.2039.9246.0846.0446.6446.82

RAID5 - 4HD;145G;15k -IO/S305.02349.08408.14638.73737.38736.64746.35749.15
2RAID1E - 4HD;300G;10k -MB/S13.6515.0115.2915.5415.4815.4915.2715.55

RAID1E - 4HD;300G;10k -IO/S218.40240.30244.76248.76247.72247.91244.35248.95
3RAID10 - 4HD;300G;10k -MB/S22.0527.0833.9157.4273.1274.5774.4473.93

RAID10 - 4HD;300G;10k -IO/S352.91433.41542.56918.761169.921193.241191.071182.93

  • Graph Presentation

B. Result extracted for write performance :

  • Table Presentation

1RAID5 - 4HD;145G;15k MB/S12.3512.1712.3912.3712.3812.4612.5412.61

RAID5 - 4HD;145G;15k IO/S197.69194.78198.24198.07198.09199.46200.67201.8
2RAID1E - 4HD;300G;10k MB/S8.428.288.258.418.498.348.398.3

RAID1E - 4HD;300G;10k IO/S134.80132.59132.03134.63135.84133.56134.27132.85
3RAID10 - 4HD;300G;10k MB/S16.6416.5816.7016.4916.5516.5616.7216.76

RAID10 - 4HD;300G;10k IO/S266.36265.36267.35263.97264.81265.09267.56268.18

  • Graph Presentation

Result : As for the interpretation of the output we can clearly see that setup in RAID 10 is far the most efficient in regards our tests scenarios. For read and write instructions it has demonstraste to be faster quite significantly and that even though in the RAID5 setup we had 15k drive rather than the 10k when setup in RAID10.

No comments: