Setting the Record Straight - 22 Aug 2000

In pre-SQL Server 7.0 releases, the checkpoint writes out any page that had changed since the last checkpoint and that another process hadn't already written out between checkpoints. So, any recovery process would begin at the last checkpoint, because any transaction committed before that checkpoint would have been written to both the transaction log and the database and would no longer be a concern.

However, SQL Server Books Online (BOL) says that in SQL Server 7.0, instead of writing out all pages changed since the previous checkpoint, the checkpoint process writes out to disk all pages that were marked as dirty before the previous checkpoint and that haven't been written out by some other process using spare CPU cycles. In other words, according to BOL, the checkpoint process doesn't write out a changed page at the next checkpoint, but at the one after that, giving the change a better chance of being written out by a worker thread or the lazywriter. The result is that each checkpoint should have less to do. In turn, the recovery process would then begin not from the last checkpoint before the system shutdown, but from the one before that. However, the BOL documentation isn't correct; the checkpoint does indeed write all changed pages to disk immediately.

Please or Register to post comments.

IT/Dev Connections

Las Vegas
September 30th - October 4th

Paul ThurottOur Experts will show you:
• Common SQL Server
Problems
• Best Practices for T-SQL
• SQL Server Integration
Services
• Database Development

Come See Mike Otey & Tim Ford in Person!

Early Registration Now Open

From the Blogs
May 9, 2013
blog

My ISO 8601-Compliant Signature 2

My family recently just "officially" announced that we're in the process of adopting a child from South Africa. We're quite excited, of course, but there's a ton of paperwork to do—along with the need for gobs of signatures....More
May 8, 2013
blog

Use SSIS for ETL from Hadoop

In this blog post, Mark Kromer walks you through using SSIS as a way to use ETL techniques using Microsoft's Hadoop on Windows (HDInsight) as a source using Hive connectors...More
Vision road sign
May 6, 2013
blog

Cheaters Never Win, Even in TPC Benchmarks

In this portion of the series on database benchmarking, I want to tell you about one of my favorite aspects of the TPC benchmarks – CHEATING....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.