Replication Server Performance Tuning

From SybaseWiki
Revision as of 23:26, 3 March 2006 by 80.126.254.102 (Talk)

Jump to: navigation, search

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"