Online Tutorials & Training Materials | STechies.com
Register Login

Disabled Statistics Server Actions

Abhijeet Mudgal || 30 Mar 2015 6:45 pm || 1

Hello Experts,

Why are some statistics server actions disabled?


Comments

  • 10 Apr 2015 5:18 pm Helpful Answer

    Disabled statistics server actions are reported with check ID 717 ("Number of disabled actions") of SQL: "HANA_Configuration_MiniChecks" .

    The most frequent root cause for disabled statistics server actions are timeouts. You can check via SQL: "HANA_StatisticsServer_Schedule" for STATUS, which contains "Disabled" and the related reason, e.g. "Disabled (timeout)".

    If you find disabled actions due to timeout, you can enable them with the following command:

    UPDATE "_SYS_STATISTICS"."STATISTICS_SCHEDULE" SET STATUS = 'Idle' WHERE STATUS = 'Disabled' AND STATUSREASON = 'timeout'

    If the same check disables itself repeatedly due to timeouts, you have to analyze the underlying performance problem.

    Another reason for disabled statistics server actions can be invalid underlying procedures. A general activation of actions regardless of the timeout reason can be performed with the following command:

    UPDATE "_SYS_STATISTICS"."STATISTICS_SCHEDULE" SET STATUS = 'Idle' WHERE STATUS = 'Disabled'