SQL Server replication
Published 14 October 2025
Redgate Monitor provides detailed visibility into the current state of replication-related Agent jobs. If your SQL Servers rely on snapshot replication, transactional replication, or merge replication processes to synchronize between databases, Redgate Monitor's Estate > SQL Server replication page provides a useful overview to check that these processes are running.
To get started, add your distributor and subscriber server/s to Redgate Monitor. See Adding SQL Server.
Amazon RDS and replication
If your replication agents are hosted on Amazon RDS server, replication jobs may appear in this page, but topology details (publisher, subscriber) are not available in Redgate Monitor.
The Estate > SQL Server replication page will display the most recent activity of each replication job identified on your monitored servers. All jobs that Redgate Monitor has observed within the last 15 minutes, having a category starting 'REPL-' are displayed on this page.
By reviewing columns such as Publisher, Subscriber, Distributor, and Publication name, you can verify that replication components are correctly configured and operating as expected.
Redgate Monitor can automatically notify you when replication processes fail. See Replication job failure and Replication maintenance job failure alerts.
| Column Name | Description | Displayed by default? |
|---|---|---|
Agent server name | The name of server hosting the replication agent. | Yes |
| Agent server group | The group the server belongs to, as defined in Redgate Monitor. | No |
| Agent server tags | Custom tags assigned to the server for filtering and categorization. | No |
Job category | The classification of the SQL Agent job (e.g., REPL-Snapshot, REPL-Merge etc.). | Yes |
| Job name | The name of the replication job being monitored. | Yes |
| Enabled | Indicates whether the job is currently enabled to run. | No |
| Job started | The timestamp when the job execution began. | No |
| Job ended | The timestamp when the job execution completed. | Yes |
| Job duration | The total time elapsed during job execution. | No |
| Status | The status of jobs currently executing (e.g. Executing, Between retries, Waiting for thread), or the outcome of the most recent job execution (e.g., Succeeded, Failed). | Yes |
| Publisher | Name of the server and database used as the source, if configured in this replication job. | Yes |
| Subscriber | Name of the database and server designated to receive replicated data, if configured in this replication job. | Yes |
Distributor | Name of the server designated to manage the flow of data, if configured in this replication job. | Yes |
| Publication name | Name of the publication configured for this replication job, if configured in this replication job. | No |
Specific columns can be displayed or hidden using the 'Columns' control at the top of the page.
