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