Why is it not recommended to use RAID 5 for a log file?
8
votes
2
answers
1381
views
While reading SQL Server Query Performance Tuning written by Grant Fritchey, I found it difficult to understand the following part: ***avoid RAID 5 for t-logs because, for every write request, RAID 5 disk arrays incur twice the number of disk I/Os compared to RAID 1 or RAID 10.***
I know that RAID 5 differentiate from other RAIDs with its parity feature. It means that if some of the drives fails, then it is possible to recover lost data from the other drives. I want to understand why it is not recommended to use RAID 5 for a transaction log file. Explanation in the book was not enough for me to get it. Maybe someone could explain it to me or provide a good article.
Asked by Rauf Asadov
(1313 rep)
Oct 28, 2019, 01:59 PM
Last activity: Oct 29, 2019, 08:17 AM
Last activity: Oct 29, 2019, 08:17 AM