Can I read Comparing Checksum vs Torn Page Detection on EtoBox?

Comparing Checksum vs Torn Page Detection by divandann is a document available to read on EtoBox.

What is Comparing Checksum vs Torn Page Detection about?

Torn page detection adds an unmeasurably small load to the database workload compared to checksum which adds approximately 2% load. Torn page detection only detects corruption if a write fails partway through while checksum detects corruption within sectors by reading the entire page and comparing checksums. Blog posts indicate page checksums should always be enabled from SQL Server 2005 onwards since the 1-2% CPU increase is negligible compared to risks of undetected corruption.

Author

divandann

Language

EN