1. Replication Guide
  2. Improving Replication Performance
  3. Adjust Transaction Log Buffer Size and CPU

Adjust Transaction Log Buffer Size and CPU

There are certain things you need to do if you are planning a replication scheme.

  • The transaction log setting for LogBufMB should result in the value of LOG_FS_READS in the SYS.MONITOR table being 0 or close to 0. This ensures that the replication agent does not have to read any transaction log records from the file system. If the value of LOG_FS_READS is increasing, then increase the transaction log buffer size.

  • CPU resources are adequate. The replication agent on the master database spawns a thread for every subscriber database. Each thread reads and processes the transaction log independently and needs adequate CPU resources to make progress.

  • If the sending side and receiving side of the replication scheme are mismatched in CPU power, place the replication receiver on the faster system.