Auto Update or Auto Create Statistics Disabled

When the auto create statistics or auto update statistics options are enabled, SQL Server collects statistics on the distribution of values in columns. Accurate statistics allow the optimizer to create more efficient query plans; which should result in better performance.

Suggested Action

Both auto create statistics, and auto update statistics should be enabled.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.

Further Reading

SQL Server Best Practices: Auto-Create and Auto-Update Statistics Should Be On – Most of the Time | Microsoft Blogs

Database Properties (Options Page) | Microsoft Docs