Sample output

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