HiveBrain v1.2.0
Get Started
← Back to all entries
principlesqlModerate

Installation of SQL Server RAID 10 vs RAID 5

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sqlraidserverinstallation

Problem

I am new to setting up SQL Servers and Vms. My predecessor used Raid 5 for C Drive where the SQL installation resided and RAID 10 for both database files and database logs.

I was wondering whether that is correct or should RAID 5 be utilized for SQL database files instead?

Any help?

Solution

I did a series of TCP-C tests against several of the common RAID levels and was surprised that in a write-heavy scenario RAID5 was over 3x slower than RAID10 (it was 319% slower, to be specific). Your mileage may vary according to the actual ratio of reads versus writes in your scenarios.

-Kev

Context

StackExchange Database Administrators Q#41941, answer score: 18

Revisions (0)

No revisions yet.