Skip to content

Latest commit

 

History

History
45 lines (40 loc) · 4.07 KB

monitoring-replication-with-system-monitor.md

File metadata and controls

45 lines (40 loc) · 4.07 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords
Monitoring Replication with Performance Monitor
Monitoring Replication with Performance Monitor
MashaMSFT
mathoma
09/25/2024
sql
replication
reference
updatefrequency5
monitoring performance [SQL Server replication], Performance Monitor
Performance Monitor [SQL Server], replication
performance counters [SQL Server replication]

Monitoring Replication with Performance Monitor

[!INCLUDE SQL Server] [!INCLUDEmsCoName] Windows Performance 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 (Performance Monitor).

Performance 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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion]: Replication Agents Running The number of replication agents currently running.
Snapshot Agent [!INCLUDEssNoVersion]: Replication Snapshot Snapshot: Delivered Cmds/sec The number of commands per second delivered to the Distributor.
Snapshot Agent [!INCLUDEssNoVersion]: Replication Snapshot Snapshot: Delivered Trans/sec The number of transactions per second delivered to the Distributor.
Log Reader Agent [!INCLUDEssNoVersion]: Replication Log reader Logreader: Delivered Cmds/sec The number of commands per second delivered to the Distributor.
Log Reader Agent [!INCLUDEssNoVersion]: Replication Log reader Logreader: Delivered Trans/sec The number of transactions per second delivered to the Distributor.
Log Reader Agent [!INCLUDEssNoVersion]: Replication Log reader 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 [!INCLUDEssNoVersion]: Replication Dist. Dist: Delivered Cmds/sec The number of commands per second delivered to the Subscriber.
Distribution Agent [!INCLUDEssNoVersion]: Replication Dist. Dist: Delivered Trans/sec The number of transactions per second delivered to the Subscriber.
Distribution Agent [!INCLUDEssNoVersion]: 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 [!INCLUDEssNoVersion]: Replication Merge Conflicts/sec The number of conflicts per second occurring during the merge process.
Merge Agent [!INCLUDEssNoVersion]: Replication Merge Downloaded Changes/sec The number of rows per second replicated from the Publisher to the Subscriber.
Merge Agent [!INCLUDEssNoVersion]: Replication Merge Uploaded Changes/sec The number of rows per second replicated from the Subscriber to the Publisher.

Related content