Which schema provides performance data and alert details to review in SAP HANA mini-checks?
Which schema provides performance data and alert details to review in SAP HANA mini-checks?
The _SYS_STATISTICS schema in SAP HANA is responsible for providing performance data and alert details. This schema contains the views generated by the statistics server, which collect historical performance data and system alerts. These statistics are crucial for monitoring the system's health and performance, making it the correct schema for reviewing performance data and alert details in SAP HANA mini-checks.
HA200-SAP HANA 2.0 SPS06 - Installation and Administration. You can use each statement separately, but you can use mini checks to execute the most important statements with one call. Use the version that best fits your system environment, so that the most comprehensive set of checks is executed. It is important to know your SAP HANA version number. The embedded statistics server assists you with monitoring the SAP HANA system, collects historical performance data, and warns you of system alerts (such as resource exhaustion). The historical data is stored in the _SYS_STATISTICS schema.
In SAP HANA mini-checks, the schema that provides performance data and alert details for review is the _SYS_STATISTICS schema. This schema contains the statistics server views that provide performance data and alert details for various aspects of the HANA system, such as memory usage, CPU utilization, disk I/O, and more. The views in this schema can be used to monitor the system's performance and identify potential issues that may require further investigation.