What is SQL Server indirect checkpoint and its performance implications?

Indirect checkpoint continuously manages dirty page flushing based on target recovery time.

Unlike automatic checkpoints, indirect checkpoints maintain a steady background flushing mechanism to control recovery time. It ensures predictable recovery performance but increases continuous IO overhead. It is especially useful in high-availability systems where recovery time objectives are strict.