Monitoring and Tuning Replication

In some ways, tuning replication involves the normal tuning that you do with any SQL Server system. In other ways, tuning replication involves tuning the specific replication agents. In this section you will see some standard replication tuning tips and techniques, along with specific tasks that must be done in order to tune specific replication types.

Monitoring Replication with perfmon

The SQL Server agents can be monitored via the Windows performance monitor tool (perfmon). Perfmon can be invoked by selecting it from the Start menu, then All Programs, Administrative Tools, and then Performance, or by selecting Run from the Start menu and typing perfmon. From the performance monitor, the SQLServer: Replication ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.