Home / server / Questions / 274521
Accepted
EkoostikMartin
Asked: 2011-05-28 05:51:48 +0800 CST

SAN device storage config for SQL 2008 cluster

  • 772

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!

sql-server sql-server-2008 storage-area-network storage

1 Answers

  1. Best Answer

    Have you read this Microsoft article? Due to the nature of each vendors san they will also be a valuable resource for stripe size, as them for their test results. I recieved an extensive white paper from Dell when I install one of their sans.

    After formatting the san and prior to installing SQL you should run SQLIO and test the performance. The formatting could be repeated with a different allocation size and the testing repeated. Although repeated formatting and testing will take some time you will only have ONE chance in getting this correct unless you want to bring down your production site to reformat your disk subsystem.

    • 5