Tips for using Transactional Replication in SQL Server 2019 (Part 2) Consider increasing the -CommitBatchThreshold parameter of the Distribution Agent. This parameter specifies the number of replication commands to be issued to the Subscriber before a COMMIT statement is issued. The default value is 1000. If you do not need continuous replication, avoid configure the Distribution Agent to run continuously….
This content is for Pro, Pro Member, Pro Member Annual – Fall Sale, Pro Member Monthly – Fall Sale, Standard, Standard Member, Standard Member Annual – Fall Sale, and Standard Member Monthly – Fall Sale members only.
Register
Register
Already a member? Log in here