Day 4–Trace Flag 3502–Log Checkpoint information to errorlog

Have you ever tried to capture when CHECKPOINT is happening to the database? If not then you can utilize trace flag 3502 to capture CHECKPOINT information to errorlog. You need to add this trace flag to SQL Server startup parameter to capture these information when CHECKPOINT triggers. This will help you to analyze how frequently checkpoint is happening in the database.