A fellow DBA questioned some strange occurrences in their environment and wanted to rule out that a checkpoint did not cause this problem. They wanted to see when the last time CHECKPOINT ran. The question was raised: Is there a way to see when the last checkpoint was run?
By default the answer is no… unless you’ve enabled TRACE FLAG 3502.
Trace Flag 3502 logs a message to the SQL Server Error Log at the start and the end of each CHECKPOINT.
Now this obviously didn’t help after the fact but if the behavior continues and they want to rule this out Trace Flag 3502 is an option.
