top) in order to understand which processes are responsible for the highest CPU consumption. SPS >= 09: Indexserver CPU information (total, system) (SAP Note 2222110)Īdditionally you should use operating system tools (e.g. SPS >= 09: Host wide CPU consumption (SAP Note 2222110)

This command provides information about the used CPUs including frequency and number. It displays the CPU utilization (in %), the number of CPUs busy with user activities, the number of CPUs busy with system activities and the number of idle CPUs. SQL: “HANA_Resources_CPUAndMemory_History”Īmong others this SQL statement is able to check for current and historic CPU consumption on a granular basis. The following SQL statements are available via SAP Note 1969700 in order to understand the CPU consumption of the SAP HANA hosts: SAP HANA Studio -> Administration -> Performance -> Load -> CPU.SAP HANA Studio -> Administration -> Overview -> CPU Usage.The following options exist to check the current CPU utilization of the SAP HANA database server: How can I collect information about the CPU consumption?

This SAP Note provides information how to analyze and optimize unnecessary CPU consumption. If on the other hand simple database requests or other processes consume a high amount of CPU, this can result in a critical CPU bottleneck situation which can be avoided. Is a high CPU consumption generally an issue?Ī high CPU consumption can be normal and acceptable, because SAP HANA uses available CPUs efficiently by parallelizing complex operations. Therefore, a high CPU consumption can be intended and a consequence of a massively parallelized processing of complex operations.

Sap hana studio system usage