Monitoring Replication

SQL Server 2012

Microsoft SQL Server Replication Monitor is a graphical tool that allows you to monitor the overall health of a replication topology. Replication Monitor provides detailed information on the status and performance of publications and subscriptions, allowing you to answer common questions, such as:

Is my replication system healthy?
Which subscriptions are slow?
How far behind is my transactional subscription?
How long will it take a transaction committed now to reach a Subscriber in transactional replication?
Why is my merge subscription slow?
Why is an agent not running?

To monitor replication, a user must be a member of the sysadmin fixed server role at the Distributor or a member of the replmonitor fixed database role in the distribution database. A system administrator can add any user to the replmonitor role, which allows that user to view replication activity in Replication Monitor; however, the user cannot administer replication.

In This Section

The following topics provide information about Replication Monitor features.

Overview of the Replication Monitor Interface: Describes each window and tab in Replication Monitor and provides information on how to answer the questions listed above.
Start the Replication Monitor: Describes how to start the Replication Monitor.
Allow Non-Administrators to Use Replication Monitor: Describes how to assign permissions to non-administrators so that they can use Replication Monitor.
Add and Remove Publishers from Replication Monitor: Describes how to add or remove Publishers from Replication Monitor.
Refresh Data in Replication Monitor: Describes how to refresh data in Replication Monitor.
Monitor Performance with Replication Monitor: Describes how to monitor performance in Replication Monitor, including information on setting performance thresholds. Includes information on article-level statistics for merge replication, which provide a detailed view of processing.
Measure Latency and Validate Connections for Transactional Replication: Describes tracer tokens, which allow you to measure the performance of a transactional replication topology.
Monitor Replication Agents: Describes how to find information about each replication agent.
Set Thresholds and Warnings in Replication Monitor: Describes the warnings, thresholds, and alerts you can set in Replication Monitor. It is recommended that you enable warnings for your topology, so that you are informed about status and performance in a timely manner.
Caching, Refresh, and Replication Monitor Performance: Describes how Replication Monitor caches data and calculations to improve performance; explains how refresh of the user interface relates to refresh of the cache.
View Publication and Subscription Status in Replication Monitor: Describes how to view status information a Publication or Subscription by using the Replication Monitor.
View Information and Perform Tasks for a Publisher (Replication Monitor): Describes how to view information and perform tasks for a Publisher by using the Replication Monitor.
View Information and Perform Tasks for a Publication (Replication Monitor): Describes how to view information and perform tasks for a Publication by using the Replication Monitor.
View Information and Perform Tasks for the Agents Associated With a Publication (Replication Monitor): Describes how to view information and perform tasks for the agents associated with a Publication by using the Replication Monitor.
View Information and Perform Tasks for a Subscription (Replication Monitor): Describes how to view information and perform tasks for a Subscription by using the Replication Monitor.
View Information and Perform Tasks for the Agents Associated With a Subscription (Replication Monitor): Describes how to view information and perform tasks for the agents associated with a Subscription by using the Replication Monitor.

Was this page helpful?

Yes

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Thank you for your feedback

Community Additions

ADD