sp_Blitz Result: Change Tracking Enabled

SQL Server’s Change Tracking feature can help data warehouses and homegrown replication solutions manage change and sync data with other databases.

This part of our SQL Server sp_Blitz script looks in sys.change_tracking_databases to see if any databases have change tracking enabled.

Is Change Tracking Performing Well?

It can sometimes have problems. Read more in our article, Performance Tuning SQL Server Change Tracking.

To Fix the Problem

Start asking around about whether this database is really supposed to have Change Tracking enabled, and if not, consider setting that back to the default.

Return to sp_Blitz or Ask Us Questions