How to terminate transaction causing high CPU Utilization in SAP HANA Database

[Soul_star]

Hi Everyone,

Is there any way to terminate/cancel the transaction causing 100% CPU for more than 5-10 min?

Is it possible to apply any specific condition on the HANA database layer/ application layer?

Or is there any other way to achieve this?

Please let me know!

Thanks,
Shruti

[Soul_star]

Hi

[Laszlo_Thoma · Accepted solution]

Hi Shruti,

2092196 - How-To: Terminating Sessions in SAP HANA

Regards,
Laszlo

[Soul_star · Accepted solution]

Hi Laszlo,

[Soul_star · Accepted solution]

Hi Laszlo, Thanks for the SAP NOTE. Is there any automatic way to terminate session which consumes high CPU

[Laszlo_Thoma · Accepted solution]

Hi Shruti,

If execution consumes high CPU (e.g. for a short or long period) not definitely means a problem. Also we need to define what is an acceptable time when execution should finish (how long should it run normally). This can be different in every execution.

So the logic is different, there is no point in auto interrupting the execution due to "high" CPU usage.

In SAP HANA database, you can do preventive actions with workload classes, so you can limit the resource which available for the specific workload class:

• 2222250 - FAQ: SAP HANA Workload Management

Regards,
Laszlo

[Soul_star · Accepted solution]

Hi Laszlo, Thank you so much for detailed information.