Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
|
||||||||||||||||
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
Reference
Replication Views (Transact-SQL)