Why are some statistics server actions disabled?
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'