https://community.sap.com/t5/technology-q-a/cause-of-hana-cloud-high-cpu/qaa-p/13723981#M4832250 <P>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.<BR />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.<BR />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.<BR />Then, you should check insufficient hardware resources for specifications and compare them with the recommended specifications for SAP HANA.<BR />Bugs in the SAP HANA software can cause high CPU usage. Check the SAP Notes and SAP Community for any known issues.</P> Fri, 07 Jun 2024 08:53:05 GMT HakanHaslaman 2024-06-07T08:53:05Z https://community.sap.com/t5/technology-q-a/cause-of-hana-cloud-high-cpu/qaq-p/13703382 <P>Hello experts,&nbsp;<BR /><BR />Recently our HANA Cloud cpu reaches to very high percentage of usage frequently, and occring delta merge at the same time.<BR /><BR />What might be the typical cause of such a situation?<BR /><BR />I want to know how to research this issue.<BR /><BR />Thanks &amp; Regards,</P><P>Daisuke.H</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HANACloud_CPU_Performance_1.jpg" style="width: 999px;"><img src="https://community.sap.com/t5/image/serverpage/image-id/111477i2520E994F3086795/image-size/large?v=v2&amp;px=999" role="button" title="HANACloud_CPU_Performance_1.jpg" alt="HANACloud_CPU_Performance_1.jpg" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HANACloud_CPU_Performance_2.jpg" style="width: 999px;"><img src="https://community.sap.com/t5/image/serverpage/image-id/111479iE4033D36721B9720/image-size/large?v=v2&amp;px=999" role="button" title="HANACloud_CPU_Performance_2.jpg" alt="HANACloud_CPU_Performance_2.jpg" /></span></P> Thu, 16 May 2024 10:00:31 GMT https://community.sap.com/t5/technology-q-a/cause-of-hana-cloud-high-cpu/qaq-p/13703382 Daisuke_H 2024-05-16T10:00:31Z https://community.sap.com/t5/technology-q-a/cause-of-hana-cloud-high-cpu/qaa-p/13723981#M4832250 <P>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.<BR />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.<BR />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.<BR />Then, you should check insufficient hardware resources for specifications and compare them with the recommended specifications for SAP HANA.<BR />Bugs in the SAP HANA software can cause high CPU usage. Check the SAP Notes and SAP Community for any known issues.</P> Fri, 07 Jun 2024 08:53:05 GMT https://community.sap.com/t5/technology-q-a/cause-of-hana-cloud-high-cpu/qaa-p/13723981#M4832250 HakanHaslaman 2024-06-07T08:53:05Z