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 0.0 0.0 0 0.0 % by Change of Database 0.0 0.0 0 0.0 % by Single Log Record 0.0 0.0 0 0.0 % by Unpin 0.0 0.0 0 0.0 % by Other 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total ULC Flushes 0.0 1.0 4 ULC Log Records 0.0 0.0 0 n/a Max ULC Size During Sample n/a n/a 0 n/a ULC Semaphore Requests Granted 0.1 4.0 16 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total ULC Semaphore Req 0.1 4.0 16 Log Semaphore Requests Granted 0.0 1.0 4 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Log Semaphore Req 0.0 1.0 4 Transaction Log Writes 0.0 0.0 0 n/a Transaction Log Alloc 0.0 0.0 0 n/a
