Take the 2-minute tour ×
Server Fault is a question and answer site for professional 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!

share|improve this question
    
possible duplicate of SAN device storage config for SQL 2008 cluster –  squillman May 27 '11 at 14:16
    
@Zack I have the same storage, did you Install the Dell MD Storage Manager already? I had problems after the installation, the shortcuts did not appear properly, and the Storage Manager utility .exe didn't have any names on the program files folder. –  Gabriel Guimarães May 27 '11 at 14:17
    
Yes, the Dell management software installed fine for me. –  EkoostikMartin May 27 '11 at 14:42
    
@Zack In my case the install was also fine, however if you check you "C:\Program Files (x86)\Dell\MD Storage Software\MD Storage Manager\client" directory there was a .exe file without a name. –  Gabriel Guimarães May 27 '11 at 18:25
add comment

1 Answer

up vote 5 down vote accepted

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.