Replication Server Performance Tuning
From SybaseWiki
Revision as of 23:43, 3 March 2006 by 80.126.254.102 (Talk)
Things about Replication Server
Performance Tuning
RepAgent
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.
