TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

MSreplication_monitordata (Transact-SQL)

 

Applies To: SQL Server

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 nameData typeDescription
lastrefreshdatetimeDate and time that the monitor data was refreshed.
computetimeintIs the time (in seconds) taken to compute monitor data.
publication_idintThe publication ID.
publishersysnameThe name of the Publisher.
publisher_srvidintThe server ID of the Publisher.
publisher_dbsysnameThe name of the publication database.
publicationsysnameThe name of the publication.
publication_typeintThe type of publication, which can be one of these values:

 0 = Transactional publication

 1 = Snapshot publication

 2 = Merge publication
agent_typeintThe 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_idintThe ID of the replication agent.
agent_namesysnameThe name of the replication agent job.
job_iduniqueidentifierThe GUID of the replication agent job.
statusintStatus of the replication agent, which can be one of these values:

 1 = Started

 2 = Succeeded

 3 = In progress

 4 = Idle

 5 = Retrying

 6 = Failed
isagentrunningnowbitA flag that indicates if the agent job is currently running, where a value of 1 means that the job is running.
warningintThreshold 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_distsyncdatetimeThe last date and time that the Distribution Agent ran.
agentstoptimedatetimeThe date and time that the agent stopped.
distdbsysnameName of the distribution database for the subscription.
retentionintThe retention period for the publication.
time_stampdatetimeInternal-use only.
worst_latencyintThe highest latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.
best_latencyintThe lowest latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.
avg_latencyintThe average latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.
cur_latencyintThe latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents during the current run.
worst_runspeedPerfintThe longest synchronization time for the merge publication
best_runspeedPerfintThe shortest synchronization time for the merge publication
average_runspeedPerfintThe average synchronization time for the merge publication
mergePerformanceintPerformance 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.
mergelatestsessionrundurationintDuration of the most recent Merge Agent run.
mergelatestsessionrunspeedfloat(53)Delivery rate of the most recent Merge Agent run.
mergelatestsessionconnectiontypeintConnection 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_unittinyintDefines the unit used when defining retention, which can be one of these values:

 1 = week

 2 = month

 3 = year

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)

Community Additions

ADD
Show:
© 2016 Microsoft