Difference between revisions of "Replication Server Performance Tuning"
From SybaseWiki
m |
m (→RepAgent) |
||
| Line 4: | Line 4: | ||
====RepAgent==== | ====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. | + | Some basic settings need to be changed to get a better througput from the RepAgent to the RepServer. Change these setting with the sp_config_rep_agent stored procedure and do a restart of the RepAgent afterwards. |
* "scan batch size", set to "10000" | * "scan batch size", set to "10000" | ||
* "scan timeout", set to 5 (seconds) (not really a performance booster) | * "scan timeout", set to 5 (seconds) (not really a performance booster) | ||
Revision as of 17:19, 4 March 2006
Contents
Things about Replication Server
Performance Tuning
RepAgent
Some basic settings need to be changed to get a better througput from the RepAgent to the RepServer. Change these setting with the sp_config_rep_agent stored procedure and do a restart of the RepAgent afterwards.
- "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 Aspects
Replication Stored Procedures
Before you mark stored procedures for replication, check and beware of the following:
