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.