SQL Server 2005 - RAID Disk / Partition Setup - Optimal Block/Cluster Size
Posted on 2010-01-04
We're setting up a new SQL 2005 Server (replacing an existing server) and are examining options for optimal RAID configuration as well as partition settings for block/cluster sizes. Existing server is also SQL 2005, running on older hardware. We have basic perfmon specs for the existing server. They are as follows:
Partition C/D - OS, Applications, Swap
Average Bytes per Read: 3,514 B
Average Bytes per Write: 6,529 B
Partition E - Transaction Logs
Average Bytes per Read: 33,951 B
Average Bytes per Write: 1,271 B
Partition F - SQL Data
Average Bytes per Read: 42,980 B
Average Bytes per Write: 10,656 B
New Server is W2K8 Enterprise x64. Spec'ing the OS/Apps partition isn't critical ... we're more concerned about nailing the best RAID settings for performance, as well as block/cluster sizes for the SQL Log and Data drives. The Log File drive will be created with four physical disks. The SQL Data drive will have 14 disks.
Any thoughts on calculating the optimal settings would be greatly appreciated. Also, if you have answers to this question, you might also have some thoughts on MBR vs. GPT initializations.
Thanks for any input -