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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
