Adaptive Server Monitoring Tables for Multiple Replication Paths

Use Adaptive Server monitoring tables to provide a statistical snapshot of the state of Adaptive Server during replication using multiple paths involving RepAgent for Adaptive Server primary databases. The tables allow you to analyze Adaptive Server performance.

Table Description
monRepLogActivity Provides information from monitor counters updated by Replication Agent
monRepScanners Provides statistics for the RepAgent Scanner task
monRepScannersTotalTime Provides information on where the RepAgent Scanner task is spending its time
monRepSenders Provides processing information on RepAgent Sender tasks
Use the additional fields in the monRepSenders Adaptive Server monitoring table to provide a statistical snapshot of data distibution if you select distibution by connection.
monRepSenders
Field Description
NumberOfCommandsProcessed Number of commands, such as insert, delete, begin trans, and commit trans that each RepAgent sender thread processes to generate LTL.
AvgBytesPerCmd Ratio of NumberOfBytesSent to NumberOfCommandsProcessed.

See Adaptive Server Enterprise > Performance and Tuning Series: Monitoring Tables > Introduction to Monitoring Tables > Monitoring Tables in Adaptive Server.