Summary
This article introduced you to Replication Monitor—a fine monitoring and troubleshooting tool included with SQL Server 2005. Replication monitoring tools have improved significantly with SQL Server 2005 as compared with previous releases. It is particularly good to see the ability to monitor replication performance in real time and to have an idea of how long it will take to deliver replicated transactions currently residing in the distribution database. Database administrators can easily configure alerts that notify them of any replication-related issues. Although Replication Monitor and SSMS should be sufficient for most monitoring and troubleshooting needs, you should still become familiar with a few system-stored procedures that can help you dig deeper, if necessary.
The next article in this series will teach you how to replicate code modules with SQL Server 2005.