Monitoring and Troubleshooting Replication Using SQL Server 2005

Friday Sep 1st 2006 by Staff

The latest release of SQL Server introduced numerous enhancements to replication, and monitoring tools have changed quite a bit. This article shows you how to monitor and troubleshoot replication issues.


Replication monitoring has the following goals:

  • Ensure that replication is running and transactions are being delivered to subscribers.
  • Verify that replication performance is acceptable. This entails delivering transactions within a reasonable time frame so that data on the subscriber(s) is consistent with data on the publisher.
  • Identify and troubleshoot any errors or replication performance issues.

Microsoft did an excellent job of addressing these monitoring needs with SQL Server 2005; the new suite of tools enables you to perform all this functionality with relative ease. The new toolset does take some time to get used to, however.

The article continues at

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved