Post reply

Auto Update Statistics for Dev DBs

  • April 6, 2006 at 2:42 pm

    #152894

    Does anyone have any comments or suggestions on keeping the "auto update statistics" activated for development databases on SQL Server 2000?  In alot of the databases, the data isn't being modified often- so would it be better to just schedule a job to run update stats once a week, or keep the auto update statistics activated?

    Thanks in advance!

  • April 6, 2006 at 3:33 pm

    #631360

    Presumably if the data is not changing much then the auto update statiistics will not be invoked much. I know the algorithym ms uses cannot be predicted easily but it sounds like leaving it on won't affect dev much anyway.

  • April 6, 2006 at 10:31 pm

    #631401

    Agreed.  Its something like 20% of changes in the table before the procs against that table are marked that the statistics are out of date.  Unless the dev's will hit a few tables hard then you may as well update stats on a weekly basis.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply