what raid config for Database server
Posted on 2008-10-13
We are about to install a new Database server (SQL Server 2000 (yeah, I know that's not the latest), and need to choose the best raid version for the array.
I have a server with 6 hotswap SCSI drive bays. I have enough discs to fill them all should that be the best way. The server has an onboard Raid Controller (PERC 4DI) , which supports all kinds of raid flavours.
Data safety is paramount, speed only slight less so... any config will give me enough storage. So what should I do?
I could setup raid 5 on 5 discs with a hot spare
or raid 10 on 4 disc with 2 hot spares
or raid 10 on 6 disc no hotpare (is this possible)
And, what kind of block size should I choose for the array / partitions?