| title | MSreplmonthresholdmetrics (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/04/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| applies_to |
|
||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 0cc9b40a-36ce-485b-9bc2-d4abd5aa6727 | ||
| caps.latest.revision | 17 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)