Export (0) Print
Expand All

Monitoring Replication with System Monitor

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:

Agent

Performance object

Counter

Description

All agents

Microsoft SQL Server: Replication Agents

Running

The number of replication agents currently running.

Snapshot Agent

SQL Server: Replication Snapshot

Snapshot: Delivered Cmds/sec

The number of commands per second delivered to the Distributor.

Snapshot Agent

SQL Server: Replication Snapshot

Snapshot: Delivered Trans/sec

The number of transactions per second delivered to the Distributor.

Log Reader Agent

SQL Server: Replication Logreader

Logreader: Delivered Cmds/sec

The number of commands per second delivered to the Distributor.

Log Reader Agent

SQL Server: Replication Logreader

Logreader: Delivered Trans/sec

The number of transactions per second delivered to the Distributor.

Log Reader Agent

SQL Server: Replication Logreader

Logreader: Delivery Latency

The current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor.

Distribution Agent

SQL Server: Replication Dist.

Dist: Delivered Cmds/sec

The number of commands per second delivered to the Subscriber.

Distribution Agent

SQL Server: Replication Dist.

Dist: Delivered Trans/sec

The number of transactions per second delivered to the Subscriber.

Distribution Agent

SQL Server: Replication Dist.

Dist: Delivery Latency

The current amount of time, in milliseconds, elapsed from when transactions are delivered to the Distributor to when they are applied at the Subscriber.

Merge Agent

SQL Server: Replication Merge

Conflicts/sec

The number of conflicts per second occurring during the merge process.

Merge Agent

SQL Server: Replication Merge

Downloaded Changes/sec

The number of rows per second replicated from the Publisher to the Subscriber.

Merge Agent

SQL Server: Replication Merge

Uploaded Changes/sec

The number of rows per second replicated from the Subscriber to the Publisher.

Community Additions

ADD
Show:
© 2014 Microsoft