The following sample shows sp_sysmon output for the “Recovery Management” section.
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- --------- --------- ------- ----------
# of Normal Checkpoints 0.00117 0.00071 1 n/a
# of Free Checkpoints 0.00351 0.00213 3 n/a
------------------------- --------- --------- -------
Total Checkpoints 0.00468 0.00284 4
Avg Time per Normal Chkpt 0.01050 seconds
Avg Time per Free Chkpt 0.16221 seconds
