Ok so I'm trying to figure out the "Optimal" Raid configuration for my environment...I know that some of it comes down to personal preference so I'll try to add a little more information.
I have two SQL server ML-370 G5 servers both with the same specs (10 HD's - Dual Controllers - Quad Core 3.0 Zeons)
One server will be used as a SharePoint database (Which I believe is fairly write intensive) and the second one will be for a Workflow program (More read). There are 2,000 Employees of which 350 may be simultaneously accessing the server at any given time. Of course reliability is of great importance but so is expandability. These are the configs I've come up with for both servers. What do you guys think?
WORKFLOW DB
ARRAY A
2 Disks (Raid 1) - OS
ARRAY B
2 Disks (Raid 1) - SQL Server & Transaction logs (Does it make too much of a difference putting on the OS Array rather than the same one as transaction?)
ARRAY C
6 Disks (Raid 6) - Data/Binaries (What I'm wondering here is if a raid 5 may be more beneficial while having a Hot Spare) - THIS IS THE BIG ONE I'M DEBATING ON. Also with the HP Proliant servers can you set a Hot Spare to replace ANY h/d in ANY Array or must you assign it to one?
CONFIGURATION 2 - SHAREPOINT DB (Letters are Arbitrary)
ARRAY D
2 Disks (Raid 1) - OS
ARRAY E
2 Disks (Raid 1) - SQL Server & Transaction logs (Does it make too much of a difference putting on the OS Array rather than the same one as transaction?)
ARRAY F
6 Disks (Raid 1+0) - Data/Binaries (I'm thinking this may be the way to go since write speed is about 2X raid 5 and I only lose 1 extra disk bringing my space available from 584GB down to 438GB)
Start Free Trial
