Optimizing Snapshot Replication


Having configured snapshot replication and learned how to administer it, we need to consider how snapshot replication functions for the topology selected for the business. In order for snapshot replication to function efficiently, it should be optimized by the DBA. You not only need to factor in the design of the publication database and hardware configurations, but you should also consider the parameter settings of the Snapshot and Distributor Agents, the kind of T-SQL statements executed, and whether there are any locks. Fortunately, there are tools that can help you identify potential bottlenecks in the system and how to alleviate any problems.


Performance Object Activity Monitor Replication Agent Execution Plan System Monitor 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Sujoy Paul 2009

Personalised recommendations