I have 10 300GB SAS 15k rpm 6Gb disks available to me on a HP P2000 SAN. I have a 150GB database and I want to configure these 10 disks for best performance. There are around 2 billion rows in one particular table and the workload consists mainly of querying out of this table and loading/deleting data into/from this table. Using SQL Server 2010 Standard Edition.
The OS for the server is on separate local disk, same type of drive, one 300GB disk mirrored. SQL Server tempdb is also on this C: drive.
So given these constraints, this is what I think would be best, but I would like to know what others think and why:
one array of 4 disks RAID10 for database files i.e. 600GB available space
one array of 4 disks RAID10 for log files, 600GB available space
one array of 2 disks RAID1 for backup, 300GB available space
The loading and deleting hit the database and log file hard which is why I have configured the log drive to have 2 disk spindles. I can live with slower backups.