MSreplication_monitordata (Transact-SQL)

The MSreplication_monitordata table contains cached data used by Replication Monitor, with one row for each monitored subscription. This table is stored in the distribution database.

Column name Data type Description

lastrefresh

datetime

Date and time that the monitor data was refreshed.

computetime

int

Is the time (in seconds) taken to compute monitor data.

publication_id

int

The publication ID.

publisher

sysname

The name of the Publisher.

publisher_srvid

int

The server ID of the Publisher.

publisher_db

sysname

The name of the publication database.

publication

sysname

The name of the publication.

publication_type

int

The type of publication, which can be one of these values:

0 = Transactional publication

1 = Snapshot publication

2 = Merge publication

agent_type

int

The type of replication agent, which can be one of these values.

1 = Snapshot Agent

2 = Log Reader Agent

3 = Distribution Agent

4 = Merge Agent

9 = Queue Reader Agent

agent_id

int

The ID of the replication agent.

agent_name

sysname

The name of the replication agent job.

job_id

uniqueidentifier

The GUID of the replication agent job.

status

int

Status of the replication agent, which can be one of these values:

1 = Started

2 = Succeeded

3 = In progress

4 = Idle

5 = Retrying

6 = Failed

isagentrunningnow

bit

A flag that indicates if the agent job is currently running, where a value of 1 means that the job is running.

warning

int

Threshold warning generated by a subscription, which can be the logical OR result of one or more of these values.

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.

last_distsync

datetime

The last date and time that the Distribution Agent ran.

agentstoptime

datetime

The date and time that the agent stopped.

distdb

sysname

Name of the distribution database for the subscription.

retention

int

The retention period for the publication.

time_stamp

datetime

Internal-use only.

worst_latency

int

The highest latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.

best_latency

int

The lowest latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.

avg_latency

int

The average latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.

cur_latency

int

The latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents during the current run.

worst_runspeedPerf

int

The longest synchronization time for the merge publication

best_runspeedPerf

int

The shortest synchronization time for the merge publication

average_runspeedPerf

int

The average synchronization time for the merge publication

mergePerformance

int

Performance of the last synchronization compared to all synchronizations for the subscription, which is based on the delivery rate of the last synchronization divided by the average of all previous delivery rates.

mergelatestsessionrunduration

int

Duration of the most recent Merge Agent run.

mergelatestsessionrunspeed

float(53)

Delivery rate of the most recent Merge Agent run.

mergelatestsessionconnectiontype

int

Connection used for the most recent Merge Agent session, which can be one of the following values:

1 = local area network (LAN)

2 = dial-up network connection

retention_period_unit

tinyint

Defines the unit used when defining retention, which can be one of these values:

1 = week

2 = month

3 = year

See Also

Reference

Replication Views (Transact-SQL)
sp_replmonitorhelpsubscription (Transact-SQL)
sp_replmonitorhelppublication (Transact-SQL)
sp_replmonitorhelppublisher (Transact-SQL)
sp_replmonitorhelpmergesession (Transact-SQL)
sp_replmonitorhelppublicationthresholds (Transact-SQL)
sp_replmonitorhelpmergesessiondetail (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)

Other Resources

How to: Programmatically Monitor Replication (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance