performance because the SQL Server query optimizer can
better determine how to evaluate a query.
However, someone says that statistics updates will cause
locks on tables at unpredictable times and impact
performance for users.
Should we turn the options on ?
If we turn them off, how can we update the statistics ?
Can it be done in the Database Maintenance Plan ?Technically, yes... it's theoretically possible for auto update statistics
to cause performance degradation under certain performance situations. But
generally speaking... the potential performance problems associated with
turning the option off... are MUCH larger than the potential problems of
leaving them on...
I normally keep them on for databases that I help to manage for customers.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:a8cd01c3eb89$eb171030$a601280a@.phx.gbl...
quote:
> According to BOL, Adding statistics improves query
> performance because the SQL Server query optimizer can
> better determine how to evaluate a query.
> However, someone says that statistics updates will cause
> locks on tables at unpredictable times and impact
> performance for users.
> Should we turn the options on ?
> If we turn them off, how can we update the statistics ?
> Can it be done in the Database Maintenance Plan ?
No comments:
Post a Comment