Category: SQL Server

Just Enable Indirect Checkpoints on All Databases, Please

In this tip I show how indirect checkpoints can help improve performance and stability of more than just checkpoint operations themselves, and stifle some (but not all) problems. I conclude that you should proactively change this setting everywhere.