Description
This wait type accumulates during certain operations on databases with Change Tracking enabled. This wait type is not documented by Microsoft so not much is known about it. This wait type is uncommon and should be investigated if any values exist
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