Monitoring Replication
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.