DB options: – Recovery intervals and Checkpoint

In this video we talk about recovery intervals. Specifically how checkpoint allows recovery intervals to be maintained. Checkpoint is a feature that allows SQL server to recover faster during an unexpected shutdown. It is important for DBAs to understand how this functionality works. We explore different type of checkpoints and the role they play in recovery In addition to some new features like accelerated database recovery. We also explore the difference between direct checkpoint versus indirect checkpoints and where and how to configure them. In spite of checkpoint being around for quite some time now it seems most database administrators are still not familiar with when and how configuring.

As we go through the video you will understand how indirect checkpoint relies on The Dirty page list whereas a direct Check Point relies on the transaction count to schedule how frequently checkpoints run. And as a result you’ll understand the role they play in completing the redo face of recovery.

https://docs.microsoft.com/en-us/sql/relational-databases/logs/database-checkpoints-sql-server?view=sql-server-ver15

More about Indirect Checkpoint in SQL Server
More about Accelerated Database Recovery