Blitz Result: Auto Update Stats Disabled

SQL Server maintains statistics that help it decide how to build better execution plans.  It periodically reviews the content of tables, updates its statistics about the distribution of data in fields, and uses that for execution plans.  By default, this happens automatically – statistics are updated when about 20% of the data in a table changes. This part of our SQL Server sp_Blitz script checks sys.databases looking for databases where auto-update-stats has been turned off.

There are rare edge cases where we don’t want statistics to change even though the data has changed, but in most cases, this is a bad idea.

You can learn more about auto create stats and auto update stats in this blog post from Kimberly Tripp.

To Fix the Problem

In SQL Server Management Studio, you can right-click on each database and go into its properties to change Auto Update Stats to Enabled. This takes effect immediately for queries executed from this point forward.

After the change, you can monitor overall system performance looking for improvements, especially around query execution plans.

Return to sp_Blitz or Ask Us Questions

css.php