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.
KeywordsError Message System Monitor Trace File Query Plan Retention Period
Unable to display preview. Download preview PDF.