Hi,
I have a question regarding automatic runstats.
I specified the online maintenance period from 2:05 to 3:05 (1 hour) to let automatic runstats runs.
But what will happen if automatic runstats cannot be finished within specified time?
Will it be continued in the next day?
I assume 100 tables need to be executed runstats. 80 tables were done within the online maintenance period.
Then what will happen to 81st -100th table? Will automatic runstats be continued beyond the online maintenance period?
If it will be continued in the NEXT online maintenance period, what will happen to other tables which are necessary to be executed runstats on as a result of the day time transactions ?
Maybe I should wait for a white paper which will be published in January, but if you have any information, please help me.
Best regards,
Masako
Hi Joachim,
Thank you for your detailed explanation.
I'd like to make sure one point.
-
If the system has free capacity autorunstats will use that capacity. e.g. when the system has 60% free capacity autorunstats will use that 60% to do it's work. As soon as the regular workload increases autorunstats will throttle back until it hits the 7%. At that point it time it will keep using the 7%.
-
Does this mean that Autorunstats will continue to use 7% even though the regular workload need more and more capacity? Or if the regular workload need more capacity, Autorunstats will use less than 7%?
Thanks and best regards,
Masako
Hello,
During the online windows automatic runstats will begin with the first table and gather stats. If it finishes within the window, the next table will be taken, This will be continued as long and there is time remaining in the online window.
If a statistics run exceeds the remaining time of the online window it will finish (it will not abort) but after execution the auto stats daemon will fall asleep until the next window.
I find it very unuseful to restrict the online window to 1hr - what should this be of use for ? Auto stats is a throttled activity anyways. The SAP recommendation is to have the online window set to the 24hrs default. Restricting it to 1 hr will cause the auto stats daemon fall behind and leave you with stats that are far from being current.
Regards,
Torsten
I don't recall the note number or other reference, but I am certain that I read something that suggested that the defined maintenance window for autorunstats should NOT include the time in which online backups are done. It has something to do with a potential problem if autorunstats (which uses a table lock) tries to run stats on a table currently being backed-up (which uses a shared lock I think).
Add a comment