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 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 bolding holding at the Distributor and waiting to be received by a Subscriber.
...
To open the Replication view of the SQL Diagnostic Manager Services tab, select the appropriate SQL Server instance, select Services, and click Replication.