change_tracking_hardened_cleanup_version not incrementing in SQL 2014 SP3
When running manual SQL 2014 SP3 Change Tracking sp_flush_commit_table_on_demand you observe change_tracking_hardened_cleanup_version is not moving forward and syscommittab table not being cleaned up even though auto-clean is enabled.
Executing: sp_flush_commit_table_on_demand 1000
The value returned by change_tracking_hardened_cleanup_version() is 1133436.
The value returned by safe_cleanup_version() is 1850878.
Executing: sp_flush_commit_table_on_demand 1000
The value returned by change_tracking_hardened_cleanup_version() is 1133436.
The value returned by safe_cleanup_version() is 2811855.
Great news! On July 28th 2019 we released SQL 2014 SP3 CU4 with the corrected cleanup code. The download is available here at Microsoft Download.
Chris Skorlinski
SQL Server Escalation Services
