Advanced Services Option

Replication Server includes the Advanced Services Option which contains enhancements to replication performance.

To activate any of the enhancements in the Advanced Services Option, you must have the REP_HVAR_ASE license file. See Replication Server Installation Guide > Planning Your Installation > Obtaining a License.

• High Volume Adaptive Replication to Adaptive Server
  Replication Server includes high volume adaptive replication (HVAR), which provides better performance compared to the current continuous replication mode when replicating into databases with identical database schema.
• Enhanced DSI Efficiency
  Enabling dsi_cmd_prefetch reduces data replication latency which decreases the length of time that Replication Server waits for results from the replicate data server through the ct_results routine, and subsequently reduces the length of time the data server waits for Replication Server.
• Enhanced RepAgent Executor Thread Efficiency
  You can improve performance in Replication Server by using the NRM thread to normalize and pack Log Transfer Language (LTL) commands in parallel with parsing by the RepAgent executor thread.
• Enhanced Distributor Thread Read Efficiency
  Enables the distributor (DIST) thread to read SQL statements directly from the Stable Queue Thread (SQT) cache. This reduces the workload from SQT and the dependency between the two, and improves the efficiency of both SQT and DIST.
• Enhanced Memory Allocation
  Use the mem_reduce_malloc parameter with configure replication server to allocate memory in larger chunks in Replication Server.
• Increase Queue Block Size
  Increase the queue block size to improve replication performance.