Learn how to a build a cloud-first strategyRegister Now


torn page detection vs checksum

Posted on 2014-08-18
Medium Priority
Last Modified: 2014-08-26
can anyone provide a management freindly low tech summary of what the risks are in not using CHECKSUM and using torn page detection for "page verifacation".

What exactly is "page verifacation".

And what exactly are either checking/detecting for? Why is one considered better than the other?

Some of the links I have read have confused me even further so some comments much more preferable.
Question by:pma111
1 Comment
LVL 37

Accepted Solution

Kimputer earned 2000 total points
ID: 40267689
Did you read the official page though:


Checksums were added later (torn in SQL 2000 vs checsum in SQL 2005). That's for a reason!
Torn page works like this, write page after page after page after each page, write the bits you need. You can still write every page TOTALLY wrong though, and then still add the bits you need. If you check the torn page bits, you would think your database is in tip top shape.
Checksum writes a checksum of the total page at the end. If you check it later, if any error occured you can easily tell it. Obviously requires more CPU, but 5 years had past, so they didn't mind it to add it as a feature.

Therefore, if you want to be sure, checksum. If you have REALLY old and slow hardware, maybe step back to torn page.

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question