Use Adaptive Server monitoring tables to provide a statistical snapshot of the state of Adaptive Server during SQL statement replication. The tables allow you to analyze Adaptive Server and Adaptive Server performance.
| Table | Description |
|---|---|
| monSQLRepActivity | Provides statistics for all open objects on DML statements replicated using SQL statement replication. |
| monSQLRepMisses | Provides statistics for replicated operations for which SQL statement replication was not used. The threshold, querylimitation, and configuration columns indicate the number of times that one of these factors prevented SQL statement replication for the object. |
See Adaptive Server Enterprise > Performance and Tuning Series: Monitoring Tables > Introduction to Monitoring Tables > Monitoring Tables in Adaptive Server.