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


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