O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required