cancel
Showing results for 
Search instead for 
Did you mean: 

Cause of HANA Cloud High CPU

Daisuke_H
Discoverer
0 Kudos

Hello experts, 

Recently our HANA Cloud cpu reaches to very high percentage of usage frequently, and occring delta merge at the same time.

What might be the typical cause of such a situation?

I want to know how to research this issue.

Thanks & Regards,

Daisuke.H

HANACloud_CPU_Performance_1.jpgHANACloud_CPU_Performance_2.jpg

Accepted Solutions (0)

Answers (1)

Answers (1)

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Kudos

High CPU usage in HANA Cloud can be cause by too many processes. So, check workload using SAP HANA Cockpit or Studio. Look for long SQL statements, high memory usage, or many active connections.
It can be also caused by Delta merge operations, because this process moves data and can be CPU-intensive. Check frequency and duration in the SAP HANA Cockpit. If too frequent, it might be due to high data change rates or small delta memory limits.
Also, a poorly optimized SQL queries can consume a lot of CPU. Use the SQL Plan Cache in the SAP HANA Cockpit to identify inefficient queries. Look for queries with high execution times, high CPU usage, or high read/write operations.
Then, you should check insufficient hardware resources for specifications and compare them with the recommended specifications for SAP HANA.
Bugs in the SAP HANA software can cause high CPU usage. Check the SAP Notes and SAP Community for any known issues.