March 9, 2011 at 11:12 am
Hi,
I have a database with 'Auto Create Statistics' / 'Auto Update Statistcis' True and with quite much traffic.
Do you think it is necessary to run 'DBCC Update statistics' daily and not in weekly base in case the previous DB options do not have the same result?
Regards,
John
March 9, 2011 at 12:23 pm
The DBCC command is really meant to be an option if you're not auto-updating stats, or if the automatic updates fail to work as expected.
On large, high-traffic tables, with lots of inserts/updates/deletes, you can run into performance problems if auto-update stats is turned on, in some cases. In those cases, you want to turn that off, and run a manual stat update during usual server maintenance. How frequently it needs to be done will be something you'll have to determine based on performance stats. It may be every few hours, or daily, or weekly, depending on things like how badly it affects query plans, how long it takes to get done, etc.
But there really isn't a need to run both, in my experience.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 9, 2011 at 3:43 pm
Do I have to manually update stats when I move cluster?
I have observe,some times, a very slow select to some big tables and views when I move from one node to another.
Thanks,
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply