Description
This wait type accumulates while a transaction commit is being performed on a table with Change Tracking enabled. This wait type is not documented by Microsoft so not much is known about it. If values are excessive then investigation is required
Resolved by
DBAs
Suggested solutions
- Only enable Change Tracking on tables and columns that are absolutely required.
- Consider using Change Data Capture instead
- Upgrade disks the database and log files are hosted on
Additional research
Performance Tuning SQL Server Change Tracking
How to: Use SQL Server Change Tracking