Hi all,

I was told that SQL Server writes to disk 64KB (one extent) at a time, is it
true? If so, what should be the stripe size if I have 5 membered RAID5? Do
I devide 64KB by 5 or 4 to get the right stripe size since each stripe size
will write its parity information on another, losing 1 disk worth of diskp
space to parity information. For example, if I have 5 9GB in RAID5, my net
available space for data would be 36 GB (4x9). This is very clear in stripe
set (RAID 0), but I am not sure with RAID5.

Please advise.

Thank you.

Sang Nahm
MS Sql Server LazyDBA home page