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