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.