SQL Server Checkpoint Process

checkpoint process is a internal mechanism which performs regularly based on number of transactions or number of pages. There is no time interval for running this.

What happends when Checkpoint performed:

  • scans log file
  • checks how many committed transactions are there
  • How many failed and how many transactions are still running.
  • Committed transactions will be moved to mdf and failed transactions will be rolled back
  • Currently running transactions will not be touched by checkpoint.

Advantages of checkpoint
Checkpoint helps in speeding up recovery process.
Checkpoint helping in committing data permanently.

Powered by k2schools