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 when there is virtually no traffic on the website so not bothered about the contention with the logs.
disk 3-10 - 8kb NTFS unit allocation size
disk 3-10 - 64kb Disk Stripe size
does this seems to be sensible, any other considerations I have omitted ?
thanks