Geeks With Blogs
Max's Blog .NET, Windows Phone, SQL Server and other exciting stuff SQL Server
Synchronous Vs Asynchronous Statistics auto update in SQL Server
Asynchronous statistics auto update in SQL Server would ensure that the statistics are not updated when a query is executed, ensuring timely response. For this option, we need to set AUTO_UPDATE_STATISTICS_ASYNC to ON and also AUTO_UPDATE_STATISTICS to ON. Here, a separate thread runs in the background, which actually does the job of updating the statistics. So updated stats are available the next time for a query. This can also work the way round, meaning that a query might be using old stats and ......

Posted On Tuesday, November 24, 2009 10:08 AM

Copyright © Max | Powered by: