Advertisement

Optimizing Merge Replication

Abstract

Now that you have a fundamental understanding of SQL Server Profiler and DTA, I will focus on the optimization of merge replication. As in Chapters 17 and 18, this chapter will describe the performance counters required for monitoring the Merge Agent. I will also demonstrate the use of the Management Data Warehouse (MDW) in selecting counters so that they can be used in the optimization of merge replication. Then I will show you how to use the trace that is generated to predict performance by using the dta executable. I will conclude with the best practices for the performance and tuning of merge replication.

Keywords

Error Message System Monitor Trace File Query Plan Retention Period 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Sujoy Paul 2009

Personalised recommendations