SQL Server: One 12-drive RAID-10 array or 2 arrays of 8-drives and 4-drives
- by ben
Setting up a box for SQL Server 2008, which would give the best performance (heavy OLTP)? The more drives in a RAID-10 array the better performance, but will losing 4 drives to dedicate them to the transaction logs give us more performance.
12-drives in RAID-10 plus one hot spare.
OR
8-drives in RAID-10 for database and 4-drives RAID-10 for transaction logs plus 2 hot spares (one for each array).
We have 14-drive slots to work with and it's an older PowerVault that doesn't support global hot spares.