View a sample output of RepAgent counter activity from sp_sysmon.
Replication Agent ----------------- Replication Agent: pubs2 Replication Server: NY_RS
per sec per xact count % of total ------- -------- ----- ----------
Log Scan Summary Number of Log Scans n/a n/a 1 n/a Amount of Time for Log Scan (ms) n/a n/a 3822 n/a Longest Time for Log Scan (ms) n/a n/a 3822 n/a Average Time per Log Scan (ms) n/a n/a 3822 n/a
Log Scan Activity Updates n/a n/a 5 n/a Inserts n/a n/a 5 n/a Deletes n/a n/a 5 n/a Store Procedures n/a n/a 0 n/a DDL Log Records n/a n/a 0 n/a Writetext Log Records n/a n/a 0 n/a Text/Image Log Records n/a n/a 10 n/a CLRs n/a n/a 0 n/a Checkpoints Processed n/a n/a 0 n/a
Transaction Activity Opened n/a n/a 7 n/a Commited n/a n/a 7 n/a Aborted n/a n/a 0 n/a Delayed Commit n/a n/a 0 n/a Maintenance User n/a n/a 0 n/a
Log Extension Wait Count n/a n/a 3 n/a Amount of time (ms) n/a n/a 7822 n/a Longest Wait (ms) n/a n/a 5110 n/a Average Time (ms) n/a n/a 2607.3 n/a
Schema Cache Usage Max Ever Used n/a n/a 0 n/a Schemas reused n/a n/a 0 n/a Forward Schema Lookups Count n/a n/a 0 n/a Total Wait (ms) n/a n/a 0 n/a Longest Wait (ms) n/a n/a 0 n/a Average Time (ms) n/a n/a 0.0 n/a Backward Schema Lookups Count n/a n/a 0 n/a Total Wait (ms) n/a n/a 0 n/a Longest Wait (ms) n/a n/a 0 n/a Average Time (ms) n/a n/a 0.0 n/a
Truncation Point Movement Moved n/a n/a 0 n/a Gotten from RS n/a n/a 0 n/a
Connections to Replication Server Success n/a n/a 0 n/a Failed n/a n/a 0 n/a
Network Packet Information Packets Sent n/a n/a 6 n/a Full Packets Sent n/a n/a 2 n/a Largest Packet n/a n/a 2048 n/a Amount of Bytes Sent n/a n/a 7695 n/a Average Packet n/a n/a 1282.5 n/a
I/O Wait from RS Count n/a n/a 6 n/a Amount of Time (ms) n/a n/a 766 n/a Longest Wait (ms) n/a n/a 206 n/a Average Wait (ms) n/a n/a 127.7 n/a
-------------------------------------------------------------------