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