TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

MSreplmonthresholdmetrics (Transact-SQL)

 

Applies To: SQL Server

The MSreplmonthresholdmetrics table defines the metrics provided for monitoring replication. This table is stored in the msdb database.

Column nameData typeDescription
metric_idintIdentifies a replication performance metric, and can be one of the following values:

 1 = expiration

 2 = latency

 4 = mergeexpiration

 5 = mergeslowrunduration

 6 = mergefastrunduration

 7 = mergefastrunspeed

 8 = mergeslowrunspeed
titlesysnameThe name of the replication performance metric.
warningbitstatusintThe bitwise identifier used to provide a warning of a threshold violation for one of the following metrics:

 1 = expiration – A subscription to a transactional publication has exceeded the retention period by more than the allowable threshold, as a percentage of the retention period.

 2 = latency – The time taken to replicate data from a transactional Publisher to the Subscriber exceeds the threshold, in seconds.

 4 = mergeexpiration – A subscription to a merge publication has exceeded the retention period by more than the allowable threshold, as a percentage of the retention period.

 8 = mergefastrunduration – The time taken to complete synchronization of a merge subscription exceeds the threshold, in seconds, over a fast network connection.

 16 = mergeslowrunduration – The time taken to complete synchronization of a merge subscription exceeds the threshold, in seconds, over a slow or dial-up network connection.

 32 = mergefastrunspeed – The delivery rate for rows during synchronization of a merge subscription has failed to maintain the threshold rate, in rows per second, over a fast network connection.

 64 = mergeslowrunspeed – The delivery rate for rows during synchronization of a merge subscription has failed to maintain the threshold rate, in rows per second, over a slow or dial-up network connection.
alertmessageidintThe ID of the error message that is displayed when the threshold warning condition occurs.
descriptionnvarchar(3000)The description of the replication performance metric
default_valuesql_variantA default value for the replication performance metric.
min_valuesql_variantThe minimum value for a bounded replication performance metric.
max_valuesql_variantThe maximum value for a bounded replication performance metric.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft