App Control Database Using AUTO_UPDATE_STATISTICS_ASYNCHRONOUSLY
Article ID: 376549
Updated On:
Products
Issue/Introduction
Why is the das database is configured with AUTO_UPDATE_STATISTICS_ASYNCHRONOUSLY enabled?
Environment
- App Control Server: All Supported Versions
- Microsoft SQL Server: All Supported Versions
Resolution
When the AUTO_UPDATE_STATISTICS_ASYNC is set to true, queries compile with existing statistics even if the existing statistics are out-of-date. The Query Optimizer could choose a suboptimal query plan if statistics are out-of-date when the query is compiled. However, statistics are typically updated soon thereafter.
App Control sets this to TRUE originally because using slightly older statistics for a quicker query compile was preferred. However, the benefits of this depend on environmental specifics (table sizes, number of indexes, frequency of data change, scheduled tasks, number of endpoints, event churn, policies, etc...).
Adjusting the feature is not currently supported (or recommended) but customers can opt to change it if so desired. See the external articles in Additional Information.
Additional Information
Feedback
