I have an MD3000 with 15 146G 15K drives, with 2 controllers. I have this setup with 1 drives as a hot spare, 2 drives a RAID 0, and the other 12 drives setup as RAID 1 (actually this becomes RAID 10 I believe). The performance from the RAID 10 array behaves like write caching is not enabled, is putting 12 drives in as RAID 1 really the same as RAID 10?
With the 12 drives, did you add them in pairs (i.e. select 2 and move them to the right side, then select the next 2 and move those, and on like that (you end up seeing the drives grouped in pairs on the right side)? That's how you do a raid 10 in MDSM.
Sidenote: Why did you select to use a raid 0? Is it just for testing/comparison? Even if the data is completely 'missable', I wouldn't use raid 0 due to the hassle involved with the host's OS and the time involved with getting the virtual disk back available to the host.
I am building a SQL server, and I plan on using the RAID 0 for tempDB. I can't find where to set the cache policy for the RAID controllers, like I do for a regular PERC card (read ahead, writeback, etc.)
When I benchmark the two drives I created, the two drives in RAID 0 and the 12 drives in RAID 10 have almost identical results, leading me to wonder if the limiting factor is something to do with the HBA throughput.
My first recommendation would be to read the SQL Deployment Guide for the MD3000i (see the following link). Although the host-to-array interconnect described is iSCSI the array RAID disk group configuration applies as well as the the back-end cabling.
The iSCSI protocol is very efficient when considering 8K or smaller blocks and when looking at I/O performance, all else being equal, latency will be a key factor.
Dev Mgr
6 Operator
•
9308 Posts
•
3 Points
271
0
Posted December 19th, 2007 11:00
Sidenote: Why did you select to use a raid 0? Is it just for testing/comparison? Even if the data is completely 'missable', I wouldn't use raid 0 due to the hassle involved with the host's OS and the time involved with getting the virtual disk back available to the host.