Blitz Result: Auto Create Stats Not Enabled

SQL Server watches queries to figure out what fields users often filter on.  When a query could benefit from knowing more about a particular field’s distribution, SQL Server decides to automatically create statistics to support the query.  By default, this happens automatically. This part of our SQL Server sp_Blitz script checks sys.databases looking for databases where auto-create-stats has been turned off.

There are rare edge cases where we want to maintain the same statistics even though data changes, but these are very, very rare edge cases.

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 Create 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