Optimal Disk Setup for OLTP SQL Server
- by Chris
We have a high transaction (lots of reads and writes) database server (running SQL 2005) that is currently set up with a RAID 1 OS partition (C:) and a RAID 5 data/log/tempdb partition (D:). The C: has 2 drives and the D: has 4 drives. The server has around 300 databases ranging from 10MB to 2GB in size.
I have been reading up on best practices for partioning the disks, but would like some opinions on our setup since we are so limited in the number of disks.
It seems like RAID 10 is popular, but I dont think we could use it with only 6 total disks to work with.
Thanks.
Update
I went with 3 RAID 1 Partitions (2 disks each)
Partition 1: OS, TempDB, Backups
Partition 2: Logs
Partition 3: Data