A SQL Server Management Studio tool that provides real-time visibility into the health, latency, and status of all replication agents and publications in a SQL Server replication topology.
- Replication status: Replication Monitor displays the status of all Publishers, Publications, and Subscriptions, showing agent status (running, failed, or waiting), latency through tracer token results, and detailed error information.
- Troubleshooting: DBAs use Replication Monitor to detect replication failures, measure end-to-end latency using tracer tokens, and review replication agent job history for troubleshooting.
- Tracer tokens: Test transactions injected into the replication stream measure the end-to-end latency from the Publisher to each Subscriber.
- Access: Replication Monitor can be accessed as a standalone tool or from within SQL Server Management Studio (SSMS). Connecting to the Distributor server provides a complete view of the replication topology.
- Alert thresholds: Configurable thresholds generate warnings when replication latency or subscriber synchronization lag exceeds defined limits, enabling proactive monitoring.
- Related terms: Replication, Transactional Replication, Merge Replication, SQL Server Agent.
