Provides statistics for SQL statements that were not successfully replicated for all open objects.
Enable the enable monitoring and per object statistics active configuration parameter for this monitoring table to collect data.
The columns for monSQLRepMisses are:
Name |
Datatype |
Description |
---|---|---|
DBID |
int |
Unique identifier of the database the process is currently using |
ObjectID |
int |
ID of the object being monitored |
InstanceID |
tinyint |
(Cluster environments only) ID of an instance in a shared-disk cluster |
DBName |
varchar(30) |
Name of database containing the object being monitored for activity |
ObjectName |
varchar(30) |
Name of the object being monitored for activity |
Threshold |
int |
Number of statements that could not be replicated as SQL because the number of affected rows was below the defined threshold |
QueryLimitation |
int |
Number of statements that could not be replicated as SQL because of a query limitation |
Configuration |
int |
Number of statements that could not be replicated as SQL because of the configuration |