Monitoring and Troubleshooting Replication Using SQL Server 2005

September 1, 2006

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 http://www.informit.com/articles/article.asp?p=603637&rl=1