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 Case threads# Block Size (KB) Out. Request Duration T1 2 64 1 120 seconds T2 2 64 2 120 seconds T3 2 64 4 120 seconds T4 2 64 8 120 seconds T5 2 64 16 120 seconds T6 2 64 32 120 seconds T7 2 64 64 120 seconds T8 2 64 128 120 seconds A. Result extracted for write performance : Table Presentation T1 T2 T3 T4 T5 T6 T7 T8 1 RAID5 - 4HD;145G;15k - MB/S 19.06 21.81 25.20 39.92 46.08 46.04 46.64 46.82 RAID5 - 4HD;145G;15k - IO/S 305.02 349.08 408.14 638.73 737.38 736.64 746.35 749.15 2 RAID1E - 4HD;300G;10k - MB/S 13.65 15.01 15.29 15.54 15.48 15.49 15.27 15.55 RAID1E - 4HD;300G;10k - IO/S 218.40 240.30 244.76 248.76 247.72 247.91 244.35 248.95 3 RAID10 - 4HD;300G;10k - MB/S 22.05 27.08 33.91 57.42 73.12 74.57 74.44 73.93 RAID10 - 4HD;300G;10k - IO/S 352.91 433.41 542.56 918.76 1169.92 1193.24 1191.07 1182.93 Graph Presentation B. Result extracted for write performance : Table Presentation T1 T2 T3 T4 T5 T6 T7 T8 1 RAID5 - 4HD;145G;15k MB/S 12.35 12.17 12.39 12.37 12.38 12.46 12.54 12.61 RAID5 - 4HD;145G;15k IO/S 197.69 194.78 198.24 198.07 198.09 199.46 200.67 201.8 2 RAID1E - 4HD;300G;10k MB/S 8.42 8.28 8.25 8.41 8.49 8.34 8.39 8.3 RAID1E - 4HD;300G;10k IO/S 134.80 132.59 132.03 134.63 135.84 133.56 134.27 132.85 3 RAID10 - 4HD;300G;10k MB/S 16.64 16.58 16.70 16.49 16.55 16.56 16.72 16.76 RAID10 - 4HD;300G;10k IO/S 266.36 265.36 267.35 263.97 264.81 265.09 267.56 268.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.