The Performance Monitor
You can use Windows Performance Monitor to monitor the health of your replication scenario. When you install SQL Server, you get several new objects and counters in Performance Monitor:
• SQLServer:Replication Agents
—This object contains counters used to monitor the status of all replication agents, including the total number running.
• SQLServer:Replication Dist
—This object contains counters used to monitor the status of the distribution agents, including the latency and number of transactions transferred per second.
• SQLServer:Replication Logreader
—This object contains counters used to monitor the status of the log reader agent, including the latency and number of transactions transferred per second.
• SQLServer:Replication ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.