principlesqlModerate
Installation of SQL Server RAID 10 vs RAID 5
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?
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
-Kev
Context
StackExchange Database Administrators Q#41941, answer score: 18
Revisions (0)
No revisions yet.