MSreplication_monitordata (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Programmatically Monitor Replication
Replication Tables (Transact-SQL)
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)