Difference between revisions of "Replication Server Performance Tuning"
From SybaseWiki
| Line 1: | Line 1: | ||
| − | == Things about Replication Server == | + | ==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" | ||
Revision as of 23:26, 3 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"
