---
title: "Checkpoint in SQL Server"  
description: "In this blog, I’m explaining the checkpoint in sql server.  The SQL Server Database Engine automatically executes the CHECKPOINT command to write all"  
author: "Sumit Kesarwani"  
published: 2013-07-10  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/545/checkpoint-in-sql-server  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# Checkpoint in SQL Server

In this blog, I’m explaining the [checkpoint](https://www.mindstick.com/blog/164/checkpoints-in-sqlserver) in [sql server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server).\

The SQL [Server Database](https://www.mindstick.com/forum/155643/how-to-create-sql-server-database-in-google-cloud) Engine automatically executes the CHECKPOINT command to write all dirty pages from the Buffer Cache of the current database to disk. Dirty pages are the data pages which were stored in the Buffer Cache and were modified, however they have not yet been written to disk. This [process](https://yourviews.mindstick.com/story/1525/7-important-factors-that-may-affect-the-learning-process) helps the SQL Server Database Engine save time during database [recovery](https://www.mindstick.com/blog/23170/3-tips-on-applying-recovery-principles-to-building-a-successful-business) in the event of a sudden system crash or an unexpected SQL Server shutdown.

##### Syntax

Checkpoint [ checkpoint_duration ]

When **checkpoint_duration** is specified, the SQL Server Database Engine attempts to perform the checkpoint within the requested [duration](https://answers.mindstick.com/qa/45301/what-is-a-short-duration-discussion). The checkpoint_duration must be an [expression](https://www.mindstick.com/articles/1861/sqlite-expressions) of type int, and must be greater than zero. When this [parameter](https://www.mindstick.com/blog/450/parameter-class-in-c-sharp) is omitted, SQL Server Database Engine automatically adjusts the checkpoint duration to minimize the [performance impact](https://www.mindstick.com/interview/34326/what-s-the-performance-impact-of-using-indexes-vs-linear-scans-in-indexeddb) on database applications.

---

Original Source: https://www.mindstick.com/blog/545/checkpoint-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.