OLTP Sql Server RAID configuration with 10 disks, allocation Unit and disk stripe size
- by Chris Wood
On a new db server I only have 10 disks to play with,
The usage is about a booking every 3-5 seconds, so not high volume, I know compromises have to be made, but my initial thoughts are -
DISK 1 & 2 - RAID 1 - OS
DISKS 3,4,5,6 - RAID 10 - Data, Indexes & TempDB
DISKS 7,8,9,10 - RAID 10 - Logs & Backup
Full backups will take place…