Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2007-08-10 : 08:38:08
|
| BOL:"You should consider setting the AUTO_UPDATE_STATISTICS_ASYNC option ON when the following characteristics apply to your application: Has experienced client request time-outs caused by one or more queries waiting for updated statistics.Requires predictable query response times, even at the expense of occasionally running queries with less efficient query plans because of outdated statistics. "Out of interest, have any of you been in either of these situations and switched asynchronous on? If so, did you notice the difference? |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2010-09-17 : 01:49:45
|
| Bump. I am interested in this too. Anyone have any experience using this feature? |
 |
|
|
|
|
|
AUTO_UPDATE_STATISTICS_ASYNC