Answer
Checkpoints flush dirty pages (modified pages) from memory to disk.
Benefits:
- Shorter crash recovery time
- Enables transaction log truncation
- Reduces buffer pool pressure
Quick Answer
CHECKPOINT writes all dirty pages (modified in buffer pool but not yet on disk) to data files. This shortens crash recovery — SQL Server only needs to replay log records after the last checkpoint. Without checkpoints, recovery would require replaying the entire log from the beginning, which could take hours.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ