sys.sp_flush_commit_table_on_demand did not delete/flush all rows under sys.dm_tran_commit_table for SQL Server Change Tracking RRS feed

  • Question

  • Hi - Currently, these are the records which are present in sys.dm_tran_commit_table. Please know my retention period is 5 minutes and Auto CleanUp is set to False as I want to manually run the auto cleanup, because it is not Auto cleaning up accordingly.

    select * from sys.dm_tran_commit_table order by commit_time

    I am using SQL Server 2019.

    When I ran the stored proc sys.sp_flush_commit_table_on_demand, it did not delete/flush all the rows under the sys.dm_tran_commit_table and keeps returning 0 rows deleted. Do I need to do something prior to executing the stored procedure? I've ran it a couple of times repeatedly but still wont delete. 

    Please advise.

    EXEC sys.sp_flush_commit_table_on_demand 1000

    Thank you.

    Thursday, July 9, 2020 1:37 AM

All replies