How deeply does 100 SQL Server Mistakes and How to Avoid Them cover RAID 1?

Links RAID-1's suitability to sequential log writes but stops short of implementation details.

RAID 1

As explained in 100 SQL Server Mistakes and How to Avoid Them

RAID-1 is a mirrored storage layout that maintains identical copies of data on separate disks.

RAID 1 mirrors data across separate disks. For transaction logs, its sequential-write behavior can make it a better I/O choice than RAID-5 or RAID-6. section 9.4

Avoid this common storage mistake:

Do not apply a blanket RAID-5 or RAID-6 policy to every database volume; SAN administrators should consider RAID-1 for log storage when possible. section 9.4
Treat RAID-1 as an I/O-performance choice for the log volume, not as a replacement for correct recovery-model and log-management practices. section 9.4

How 100 SQL Server Mistakes and How to Avoid Them covers it

Cover of 100 SQL Server Mistakes and How to Avoid Them

liveBook manning.com

Read 100 SQL Server Mistakes and How to Avoid Them on liveBook Get the book at manning.com

Also explained in

liveBook manning.com

PostgreSQL Mistakes and How to Avoid ThemRAID 1 is a RAID level that maintains byte-for-byte copies of data on multiple disks through mirroring.

Compare how 2 books explain RAID 1 →

Related concepts

RAIDkind of · RAID is a storage technology that combines multiple disk drives to provide selected characteristics of capacity, performance, redundancy, or fault tolerance.

This explainer was generated by Manning's knowledge graph from the text of 100 SQL Server Mistakes and How to Avoid Them. The section links point to the parts of the book it draws on.