Udostępnij za pośrednictwem


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

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.

Zobacz także

Odwołanie

Replication Views (Transact-SQL)

Koncepcje

Replication Tables (Transact-SQL)