The following sample shows sp_sysmon output for the “Transaction Management” categories.
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- --------- --------- ------- ----------
by Full ULC 0.0 0.0 0 0.0 %
by End Transaction 120.1 1.0 7261 99.7 %
by Change of Database 0.0 0.0 0 0.0 %
by System Log Record 0.4 0.0 25 0.3 %
by Other 0.0 0.0 0 0.0 %
------------------------- --------- --------- -------
Total ULC Flushes 120.5 1.0 7286
ULC Log Records 727.5 6.1 43981 n/a
Max ULC Size n/a n/a 532 n/a
ULC Semaphore Requests
Granted 1452.3 12.1 87799 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- --------- --------- -------
Total ULC Semaphore Req 1452.3 12.1 87799
Log Semaphore Requests
Granted 69.5 0.6 4202 57.7 %
Waited 51.0 0.4 3084 42.3 %
------------------------- --------- --------- -------
Total Log Semaphore Req 120.5 1.0 7286
Transaction Log Writes 80.5 0.7 4867 n/a
Transaction Log Alloc 22.9 0.2 1385 n/a
Avg # Writes per Log Page n/a n/a 3.51408 n/a
