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


Suggested solutions

  1. Only enable Change Tracking on tables and columns that are absolutely required.
  2. Consider using Change Data Capture instead
  3. 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

⇐ Back to index