About Auto_update_statistics
Sep 4, 2007My db is about 80G, and I turned this option auto_update_statistice on
How can i know when this run? How can i say if this is running at inappropriate times?
Many thanks
ADVERTISEMENT
AUTO_UPDATE_STATISTICS A Good Idea?
May 20, 2003Can anyone tell me if turning on the AUTO_UPDATE_STATISTICS option will have any adverse effects on performance? I've read that it is possible for it to adversely affect performance, because SQL Server “takes a quick break to update database statistics in the middle of the day”. The book does not explain why and I'm always leery of simply accepting something, simply because I’ve read it from a book. This is the first time that I’ve ever heard this and cannot find anything from SQL BOL or any other source.
View 2 Replies View RelatedUpdate Statistics, Auto_Update_Statistics - Please Clarify
Sep 27, 2006Test Qn
View 5 Replies View Related