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.
Value
Metric 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.
See Also
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables