FIX: Tlog grows quickly when you run auto cleanup procedure in SQL Server 2014, 2016 and 2017

Applies to: SQL Server 2017 Developer WindowsSQL Server 2017 Enterprise Core WindowsSQL Server 2017 Enterprise Windows

Symptoms


Consider the following scenario:

  • Assume that you install Microsoft SQL Server 2014, 2016 or 2017.
  • You enable the Change Tracking feature on any of the tables in your database. You also enable auto cleanup in this database.
  • When the auto cleanup procedure runs in this database, you notice that the Transaction Log (Tlog) grows quickly.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. 

Resolution


Cumulative Update Information:

This issue is fixed in the following cumulative updates for SQL Server:

About cumulative updates for SQL Server:

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

References


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