The Replication view allows you to analyze data replication details for the selected SQL Server instance. Included are the topology and key metrics that detail the current state of active subscribed and non-subscribed transactions on all SQL Server instances related to replication on the monitored SQL Server. For more information about replication, see the Microsoft document,
| Newtablink |
|---|
| alias | SQL Server Replication |
|---|
| url | https://msdndocs.microsoft.com/en-us/library/ms151198%28v=SQL.100%29.aspx/sql/relational-databases/replication/sql-server-replication?view=sql-server-ver15 |
|---|
|
.
| Note |
|---|
Collecting replication statistics can have a performance impact on the monitored SQL Server instance. |
...
The following elements in the Replication view help you make sure that proper replication is occurring and that your data is distributed to the correct subscribers.
Replication Trends
The Replication Trends view on the Services tab, displays information about the following metrics:
- The Non-Distributed Count graph tracks the number of replication transactions published by the Publisher but not received by the Distributor.
- The Non-Distributed Time graph tracks the time in seconds that a replication transaction has been holding at the Publisher and waiting to be received by a Distributor.
- The Non-Subscribed Count graph tracks the number of replication transactions received by the Distributor and not received by a Subscriber.
- The Non-Subscribed Time graph tracks the time in seconds that a replication transaction has been holding at the Distributor and waiting to be received by a Subscriber.
Replication Topology
The Replication topology grid displays all replication sessions in which the selected server is participating, whether it is a publisher, distributor, or subscriber. For merge and snapshot replication, SQL Diagnostic Manager must monitor the distributor. For transactional replication, we recommend that you monitor the distributor, publisher, and subscriber for a complete set of metrics. Note that SQL Diagnostic Manager displays a subset of data for each monitored participant. Right-click a row or session to navigate to the participant for more information.
...
To open the Replication view of the SQL Diagnostic Manager Services tab, select the appropriate SQL Server instance, select Services, and click Replication.