• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 439
  • Last Modified:

Optimal Cluster Allocation/RAID Stripe Size on SQL 2000

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.

Thanks,
Troy
0
Natldiag
Asked:
Natldiag
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>so I am not concerned at all about wasting space due to larger clusters
you won't loose any space at all on the database files, as they are BIG compared to the cluster/stripe size.

optimal is everthing that is multiple of 64K, as that is the page size in SQL Server 2000 (and 2005)
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now