MSreplmonthresholdmetrics (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Column name Data type Description
metric_id int Identifies 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
title sysname The name of the replication performance metric.
warningbitstatus int The 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.
alertmessageid int The ID of the error message that is displayed when the threshold warning condition occurs.
description nvarchar(3000) The description of the replication performance metric
default_value sql_variant A default value for the replication performance metric.
min_value sql_variant The minimum value for a bounded replication performance metric.
max_value sql_variant The maximum value for a bounded replication performance metric.

See Also

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