SQL Server: One 12-drive RAID-10 array or 2 arrays of 8-drives and 4-drives
Posted
by
ben
on Server Fault
See other posts from Server Fault
or by ben
Published on 2011-11-23T19:36:05Z
Indexed on
2011/11/24
10:01 UTC
Read the original article
Hit count: 399
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.
© Server Fault or respective owner