monSQLRepMisses

Description

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.

Columns

Name	Datatype	Attribute	Description
dbid	int		Database ID
objectid	int		Object ID
dbname	varchar(30)		Database name
objectname	varchar(30)		Object name
threshold	int	counter	Number of statements not replicated using SQL statement replication, because they lie below a threshold
querylimitation	int	counter	Number of statements not replicated using SQL statement replication, due to limitations of the query itself
configuration	int	counter	Number of statements not replicated using SQL statement replication, because the configuration does not allow it

Example

The following sample monSQLRepMisses table depicts rows that were not replicated using SQL statement replication:

3000 statements not replicated as statements because they affected fewer number of rows than the threshold
2 statements not replicated as statements because the query did not allow it
20 statements not replicated as statements because the configuration did not allow it

dbid	objectid	dbname	objectname	threshold	querylimitation	configuration
4	608002166	db1	t2	3000	2	20