Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Windows Server 2008 R2 (clustered active/passive) - SQL Server 2008 Enterprise - Dell MD3200i PowerVault SAN

8 x 450GB 15k SAS drives (RAID 10)

What is the best stripe unit size for this configuration (for optimum SQL performance)?

I am reading conflicting reports of 64k, 128k or 256k.

Please help! Thank you!


merged by splattne May 27 '11 at 14:55

This question was merged with SAN device storage config for SQL 2008 cluster because it is an exact duplicate of that question.

migrated from stackoverflow.com May 27 '11 at 13:57

This question came from our site for professional and enthusiast programmers.