Replication Server Performance Tuning
Things about Replication Server
Some basic settings need to be changed to get a better througput to the RepServer. Change these setting with the sp_config_rep_agent stored procedure.
- "scan batch size", set to "10000"
- "scan timeout", set to 5 (seconds) (not really a performance booster)
- "send buffer size", set to "16k"
- Check if "batch ltl" is set to true.
How can you tell if a RepAgent cannot keep up with sending the transaction log to the Replication Server?
Replication Stored Procedures
Before you mark stored procedures for replication, check and beware of the following: