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 |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2007-12-07 : 03:20:18
|
| Hi all, We are using SQL Server 2005. The auto update statistics and auto create statistics for a database is set to ON. This database has a very heavy work load. When I checked the individual statitics , still the last updated statistics is in a old date value (few months ago).Is it necessary to manually update the statistics for the same database? Or can we rely upon "auto update statistics" itself ?Usually in what frequency the manual UPDATE STATISTICS should be run on production system which has heavy transactions ?Thanks & Regards,Hariarul |
|
|
pootle_flump
1064 Posts |
Posted - 2007-12-07 : 03:42:42
|
| The auto update is only triggered once there have been changes to 20% of the values since the last update. Changes to 19% will likely make a big difference to your queries as they won't be reflected in the statistics. We manually update ours regularly however we are not a 24/7 shop so it is easy for us to do that. I would also strongly consider using the new asynchronous auto update option for 2005. |
 |
|
|
|
|
|
Concern on auto update statistics