Improves the Distribution Agent cleanup procedure to increase the transactional replication performance in SQL Server 2016

Gilt für: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core


This update makes the Distribution Agent cleanup procedure adaptable to performance characteristics by increasing or decreasing the cleanup batches dynamically. This, in turn, stabilizes the transactional replication performance in Microsoft SQL Server 2016. Additionally, the subscription cleanup is now moved from the Distribution Agent cleanup job to Expired subscription cleanup job.


Service pack information for SQL Server 2016

This update is included in the following service pack for SQL Server: 

       Service Pack 2 for SQL Server 2016


Learn about the terminology that Microsoft uses to describe software updates.