December 11, 2025 at 11:32 am
I have change tracking configured in several databases, in QA and production environments, and we have config in place to feed from these databases to data warehouse databases. It works well, but ...
In a QA environment, we have been receiving the following sev-16 alert for a few days:
Change tracking autocleanup is currently not able to maintain retention for database ID n. Number of expired records: 1928. If this warning persists, check the following resource: https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/cleanup-and-troubleshoot-change-tracking-sql-server
I have checked the suggested 'resource', but cannot seem to get to the bottom of this. Autocleanup appears to be running without issue.
Can anyone explain exactly what is meant by an 'expired record' in this context and perhaps suggest some steps I can take to identify or resolve this issue?
Thanks for any suggestions!
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply