Skip to Content
author's profile photo Former Member
0
Former Member

What will happne to Automatic Runstats?

Posted on Dec 06, 2006 at 03:34 AM 25 Views

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 26, 2006 at 03:35 AM
    2

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jan 10, 2007 at 07:50 PM

      Hi Masako,

      Autorunstats will try to get 7% of the resources even if the system is busy. At that point in time it is competing with all the other applications and if the whole system slows down then autorunstats will slow down as well and might not get the 7% it could use.

      There is no mechanism in place to pause autorunstats at all if the system is under stress.

      I hope this answers your question.

      Regards,

      Joachim

  • author's profile photo Torsten Ziegler
    Torsten Ziegler
    Posted on Dec 06, 2006 at 03:28 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Dec 20, 2006 at 03:05 PM

      Hi Masako,

      Autorunstats is not using the instance wide global parameter (UTIL_IMPACT_LIM). This parameter is defined by the system administrator to control utilities he can start at a certain time. In that case the administrator knows that his system will be impacted by lets say 40%. Autorunstats runs automatically every 2 hours on it's own and you don't want to take a performance hit of 40% every 2 hours. Therefore autorunstats has a hard coded upper limit of 7% when the system is fully utilized.

      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%.

      A second exception is when there is already another utility running then Autorunstats will use the free capacity between what that utility is using up to UTIL_IMPACT_LIM.

      Lets say the limit is defined at 40%, online backup is running and uses 20%, if autorunstats kicks in it will use the difference between UTIL_IMPACT_LIM and what online backup is using in this case 20%.

      Does this answer your questions?

      Regards,

      Joachim

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2007 at 07:51 PM
    0

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.