COMMIT_ACT

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

  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

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index