torn page detection vs checksum

Posted on 2014-08-18
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 35

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how the fundamental information of how to create a table.

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now