quick sql setup check

[davetherave2]

Just got a new server with 16 x 10K (300GB) disks and just want to make sure this is the best way to set up the disk config for sql 2012


Disk 1 - 2 (OS Raid 1) (2 disks)
Disk 3 - 7 (Data Drive Raid 5) (5 disks)
Disk 8 - 12 (Transaction log drive Raid 5) (5 disks)
Disk 13 - 14 (Database file backup drives Raid 1) (2 Disks)
Disk 15 - 16 (Hot swap spares) (2 disks) - In event of failure

Does this seem sensible or should I be looking at a different setup.

Has been a while since I set up a server and would usually consider this to be a safe bet for setup for sql but just wondering if there is a better config.

Thanks in advance.

 

[davetherave2]

thanks for the info.

The backup drive is purely to put full file backup files to be able to restore quickly in the event a database goes down.

We have a barracuda backup solution in place to do full backup's etc.


Will there be much of a performance decrease from having the transaction logs on a raid 5 as opposed to raid 10

 

[davetherave2]

well this will be going onto a 2008 r2 server with sql 2012 standard license.

I have advised to move the tlog drive to raid 10 (6 disks) which should give us enough head room for now. If we need to upgrade performance in the future then we will attach a dedicated san array to handle more disk i/o

it certainly gives me more things to look at.