Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

Try hard not to use RAID 5 for ANYTHING, especially with large 7.2krpm disks as they're statistically likely to introduce unrecoverable data errors during any disk replacement/rebuilding activities. RAID 10 is by far and away the best option from a performance and data integrity perspective, in fact I'd go as far as saying that using R5 is considered unprofessional by seasoned pros these days.

share|improve this answer
    
The only exceptions I might make for RAID5 in today's world are specific SAN implementations that minimize the risks with RAID5. 3PAR arrays come to mind in the way they use chunklets and custom silicon which leads to incredibly fast rebuild times with very minimal performance impact. –  Rex May 10 '13 at 19:01
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.