Provides statistics for SQL statements that were successfully replicated on all open objects.
Enable the enable monitoring and per object statistics active configuration parameters for this monitoring table to collect data.
The columns for monSQLRepActivity 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 |
UpdateStmts |
int |
Number of update statements replicated as SQL |
InsertSelectStmts |
int |
Number of insert and select statements replicated as SQL |
DeleteStmts |
int |
Number of delete statements replicated as SQL |
SelectIntoStmts |
int |
Number of select into statements replicated as SQL |
RowsThreshold |
int |
Low boundary range for the number of rows affected by the statements |