The Event tracing Help topic for 16.0 says this...
"System trace events These are trace events that the database server generates. Trace events are generated for operations such as starting or ending a checkpoint and starting or stopping a database."
... but SELECT * FROM sp_trace_events() doesn't seem to list any events for checkpoints.
asked 31 Mar '13, 10:41
Currently in 16.0 system trace events exist for request level log, http/https log, and console log. There is no specified system trace event for checkpoints (yet!) but you can use the
answered 04 Apr '13, 10:39