• GilaMonster (12/19/2012)


    abitguru (12/19/2012)


    We dont use auto update. And is hard to find a "slow/off time" .. you know. We are thinking the best way to schedule to run in spare time.

    If you have auto_update off then you must manually maintain your statistics (all of them). With it on, you can get away with just manually updating stats where the 20% threshold is too high.

    I concur.

    I also wonder WHY you have disabled auto update stats!?!

    I recommend Ola.Hallengren.com for all of your maintenance needs, including index/statistics activities.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service