change_tracking_hardened_cleanup_version not incrementing in SQL 2014 SP3

Share this Post

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.

 

We’re aware of this problem and working on update for next SQL 2014 Cumulate Update.

While waiting for next SQL 2014 CU to be released, if syscommittab growth is causing performance impact, script out disable\enable Change Tracking, executing at scheduled maintenance window to cleanout all Change Tracking metadata tables.

Chris Skorlinski
SQL Server Escalation Services


Share this Post

About: ReplTalk


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.