I’ve been looking into the AUTO_UPDATE_STATISTICS_ASYNC option for SQL Server lately and found a couple decent articles on there on it.
Preventing the blocking of queries in OLTP environment from statastic updates seems like a good thing.
I’ve been looking into the AUTO_UPDATE_STATISTICS_ASYNC option for SQL Server lately and found a couple decent articles on there on it.
Preventing the blocking of queries in OLTP environment from statastic updates seems like a good thing.