Replication Server Performance Tuning

From SybaseWiki
Revision as of 00:37, 4 March 2006 by Psap (Talk | contribs)

Jump to: navigation, search

Things about Replication Server

Performance Tuning


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.

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: