seniorT-SQL

What is database checkpoint and how does it improve recovery performance?

Updated May 17, 2026

Short answer

Checkpoint flushes dirty pages from memory to disk to reduce recovery time.

Deep explanation

A checkpoint writes modified pages (dirty pages) from buffer cache to disk and updates the log to mark a recovery point. This reduces the number of log records that must be processed during crash recovery. SQL Server uses automatic checkpoints based on workload and recovery interval configuration.

Unlock with a Pro subscription to view this section.

View pricing

Real-world example

No real-world example available yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

Common mistakes

No common mistakes listed yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

Follow-up questions

No follow-up questions available yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

More T-SQL interview questions

View all →