App Control Database Using AUTO_UPDATE_STATISTICS_ASYNCHRONOUSLY
search cancel

App Control Database Using AUTO_UPDATE_STATISTICS_ASYNCHRONOUSLY

book

Article ID: 376549

calendar_today

Updated On:

Products

Carbon Black App Control (formerly Cb Protection)

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