September 21, 2012 at 10:28 am
Hi All,
Hope all is well.
Currently I am updating statistics on specific tables (identified them based on modified rows) daily at 2:00AM. Are there any disadvantages if I update stats twice or thrice a day?
Thanks for ur inputs.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 21, 2012 at 10:42 am
How big is the table? How frequently is it changed and what percentage of rows? How frequently is it accessed?
September 21, 2012 at 10:46 am
I have seen it where once a week is good enough, but i have also seen it where it needed to be run every two hours to keep the application performance where it needed to be. Really comes down to "it depends."
Please note, where it was being run every two hours, it was on a single, large, volitale table.
September 23, 2012 at 11:35 am
Sapen (9/21/2012)
Currently I am updating statistics on specific tables (identified them based on modified rows) daily at 2:00AM.
Just curious, are you applying your own algortihm using sys.sysindexes.rowmodctr?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply