Versions Compared

Old Version 4

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version 5

changes.mady.by.user Wara Hermosa

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 bolding 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.

...