Monitoring Replication with System Monitor

 

Applies To: SQL Server 2016

Microsoft Windows System Monitor allows you to use graphs, charts, and reports to gauge the efficiency of your computer, and identify and troubleshoot possible problems (such as unbalanced resource use, insufficient hardware, or poor program design), and plan for additional hardware needs. For more information, see Monitor Resource Usage (System Monitor).

System Monitor uses performance objects and counters, which provide information on the performance of various processes. You can measure replication performance through counters associated with the replication agents:

AgentPerformance objectCounterDescription
All agentsMicrosoft SQL Server: Replication AgentsRunningThe number of replication agents currently running.
Snapshot AgentSQL Server: Replication SnapshotSnapshot: Delivered Cmds/secThe number of commands per second delivered to the Distributor.
Snapshot AgentSQL Server: Replication SnapshotSnapshot: Delivered Trans/secThe number of transactions per second delivered to the Distributor.
Log Reader AgentSQL Server: Replication LogreaderLogreader: Delivered Cmds/secThe number of commands per second delivered to the Distributor.
Log Reader AgentSQL Server: Replication LogreaderLogreader: Delivered Trans/secThe number of transactions per second delivered to the Distributor.
Log Reader AgentSQL Server: Replication LogreaderLogreader: Delivery LatencyThe current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor.
Distribution AgentSQL Server: Replication Dist.Dist: Delivered Cmds/secThe number of commands per second delivered to the Subscriber.
Distribution AgentSQL Server: Replication Dist.Dist: Delivered Trans/secThe number of transactions per second delivered to the Subscriber.
Distribution AgentSQL Server: Replication Dist.Dist: Delivery LatencyThe current amount of time, in milliseconds, elapsed from when transactions are delivered to the Distributor to when they are applied at the Subscriber.
Merge AgentSQL Server: Replication MergeConflicts/secThe number of conflicts per second occurring during the merge process.
Merge AgentSQL Server: Replication MergeDownloaded Changes/secThe number of rows per second replicated from the Publisher to the Subscriber.
Merge AgentSQL Server: Replication MergeUploaded Changes/secThe number of rows per second replicated from the Subscriber to the Publisher.

Monitoring (Replication)

Community Additions

ADD
Show: