What is CHECKPOINT Process in the SQL Server ?

CHECKPOINT process writes all in-memory dirty pages for the current database to disk. Dirty pages are data pages that have been entered into the buffer cache and modified but not yet written to disk. Checkpoints save time during a later recovery by creating a point at which all dirty pages are guaranteed to have been written to disk.



You May Interest

Disabling All Constants in a Table in MS SQL

What are Table Valued Parameters ?

What is the Difference Between Clustered and a Non-clustered Inde ...

Getting List of All Views in MS SQL Database

What is an Online Rebuilding of Indexes in SQL Server ?