MSreplmonthresholdmetrics (Transact-SQL)

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 these values.

ValueMetric Name
1expiration
2latency
4mergeexpiration
5mergeslowrunduration
6mergefastrunduration
7mergefastrunspeed
8mergeslowrunspeed

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.