Monitoring (Replication)

APPLIES TO: yesSQL Server yesAzure SQL Database (Managed Instance only) noAzure SQL Data Warehouse noParallel Data Warehouse

Monitoring a replication topology is an important aspect of deploying replication. Because replication activity is distributed, it is essential to track activity and status across all computers involved in replication. With the use of various monitoring tools, you can answer such common questions 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?

The following tools can be used to monitor replication:

  • SQL Server Replication Monitor - the most important tool for monitoring replication, presenting a Publisher-focused view of all replication activity. For more information, see Monitoring Replication.

  • SQL Server Management Studio - provides access to Replication Monitor. It also allows you to view the current status and last message logged by the following agents and allows you start and stop each agent: Log Reader Agent, Snapshot Agent, Merge Agent, and Distribution Agent. For more information, see Monitor Replication Agents.

  • Transact-SQL (T-SQL) and Replication Management Objects (RMO) - Both interfaces allow you to monitor all types of replication from the Distributor. Merge replication also provides the ability to monitor replication from the Subscriber.

  • Alerts for replication agent events - Replication provides a number of predefined alerts for replication agent events, and you can create additional alerts if necessary. Alerts can be used to trigger an automated response to an event and/or notify an administrator. For more information, see Use Alerts for Replication Agent Events.

  • System Monitor - can be useful for monitoring performance, providing a number of counters for replication. For more information, see Monitoring Replication with System Monitor.

See Also

Best Practices for Replication Administration