Optimal Cluster Allocation/RAID Stripe Size on SQL 2000
Posted on 2006-06-30
Hello everyone. I am about to add another RAID 1+0 array to my SQL 2000 database. It will be (14) HP Ultra320 Drives, 72 Gig, 15k RPM. It will have the top-of-the-line SA 6404 Controller, with 512 Megs of Battery-Backed Read/Write Cache. It will all be in an MSA3000 Dual-Bus RAID Cage. I will be getting full U320 speed, and that is what this upgrade is all about: SPEED. I am moving one of our main databases from a shared RAID 1+0 array to its own on this new system, and giving it its own dedicated Log array as well.
So now that you have the "environment", the question: What is the optimal Cluster Allocation and RAID Stripe sizes for pure speed in SQL? We have PLENTY (and I do mean plenty) of physical space on the drives, so I am not concerned at all about wasting space due to larger clusters. Most things I have read have said 64K for both the clusters and the stripe, but I have also read a few things recently that recommend 64k for the cluster and 128k for the stripe.
Anyone have any thoughts? I am implementing this tomorrow (Saturday July 1st), so any input is greatly appreciated.