SQL Server Performance

Auto update stats asynch

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by MattEvans, Feb 22, 2008.

  1. MattEvans New Member

    Hi all,
    I was hoping to get some feedback about AUTO_UPDATE_STATISTICS_ASYNC.
    Is is true that for this to take effect both AUTO_UPDATE_STATISTICS AND AUTO_UPDATE_STATISTICS_ASYNC need to be set to true? I have read a couple of posts which imply that it is?
    i.e. is AUTO_UPDATE_STATISTICS_ASYNC a sort of modifier to AUTO_UPDATE_STATISTICS
    Any feedback appreciated.
  2. MattEvans New Member

    Apologies. Should have RTFM
    From books online: "The AUTO_UPDATE_STATISTICS_ASYNC option is set at the database level and determines the update method for all statistics in the database. It is applicable only to statistics updating and cannot be used to asynchronously create statistics. Setting this option to ON has no effect unless AUTO_UPDATE_STATISTICS is also set to ON. "

Share This Page