Skip to Content
0
Former Member
Jun 25, 2014 at 07:51 AM

How to limit threads in HANA?

2084 Views

Hi ,

I have created a report on HANA. When we execute this report, I observed that there are more than 500 threads running parallely for SQL statement.

HANA is generating lot of JobWorker(plan executor) threads and it is using 99% CPU and all the Memory present in HANA

Can anyone let me know how to limit the runnable threads in HANA for a given SQL statement?

Is there a way to know more about these Threads and as to on what basis does HANA create these threads?

I will be very grateful for your help and advice.

Thanks and Regards,

Shreepad Patil