Microsoft® SQL Server 2012 Unleashed

Indirect Checkpoints

Introduced in SQL Server 2012, indirect checkpoints provide a mechanism for configuring checkpoint intervals at the individual database level. Indirect checkpoints can provide potentially faster, more predictable recovery times for your critical databases than automatic checkpoints.

In addition to providing finer control over database recovery time for specific databases, indirect checkpoints can also help reduce checkpoint-related I/O spikes by continually writing dirty pages to disk in the background. However, an online transactional workload on a database that is configured for indirect checkpoints could experience performance degradation because the background writer used by the indirect checkpoint process may increase ...