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
-------------------------------------------------------------------