O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required