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

Improvement


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.

Resolution


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

References


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