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 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)