Difference between revisions of "Replication Server Performance Tuning"
From SybaseWiki
| Line 8: | Line 8: | ||
* "scan timeout", set to 5 (seconds) (not really a performance booster) | * "scan timeout", set to 5 (seconds) (not really a performance booster) | ||
* "send buffer size", set to "16k" | * "send buffer size", set to "16k" | ||
| + | * Check if "batch ltl" is set to true. | ||
Revision as of 00:43, 4 March 2006
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.
