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
Read More »