What Is the Purpose of Checkpoints in SQL Server?

Senior MS SQL

Answer

Checkpoints flush dirty pages (modified pages) from memory to disk.

Benefits:

  • Shorter crash recovery time
  • Enables transaction log truncation
  • Reduces buffer pool pressure

Want to bookmark, take notes, or join discussions?

Sign in to access all features and personalize your learning experience.

Sign In Create Account

Source: SugharaIQ

Ready to level up? Start Practice