Hello Experts,
Why are some statistics server actions disabled?
Disabled Statistics Server Actions
Updated May 18, 2018
Comments
Recommended Posts:
- SAP HANA Training Tutorials for Beginners
- SAP HANA In-Memory Database
- SAP HANA Database Architecture
- SAP HANA Studio Guide
- SAP HANA Azure Architecture
- SAP HANA Modeling Guide
- SAP HANA Modeling Scenarios
- Rename HANA Schema
- SAP HANA Sidecar
- SAP HANA Calculation View
- SAP HANA vs S/4HANA
- SAP HANA Security Overview
- SAP HANA Compression Techniques
- SAP HANA SQL Operators
- SAP HANA Data Provisioning
- SAP HANA Persistence layer
- SAP HANA Replication Modes
- SAP HANA Audit
- SAP HANA Interview Questions
- GST S/4HANA Master Data Configuration
×
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'