March 16, 2018 – SQL Padawan

What the Checkpoint does?

Checkpoints flush dirty data pages from the buffer cache of the current database to disk. This minimizes the active portion

To see how many VLFs you have solely look at the number of rows returned by DBCC LOGINFO. The size