Skip to Content

What is impact of no of threads in HANA Query execution and CPU usage?

We are performing a load testing for the application built on HANA. We have increased the number of concurrent users from 10 to 50 to run multiple (1-5) reports.

Initial observation: During above load test when the concurrent user reached to 50, CPU utilization increased in 99% and average time for query average execution time taken as 120 seconds.

Follow up: We have noticed the number of threads in HANA related to executing this query is 25 plus.

We have limited the thread Limit to 2 and observed improvement in initial observation

Revised observation:

After reducing the thread, we are able to run 100 concurrent reports and CPU usage is <20 % and average time take is 40 seconds.

Please help me to understand the following

  • What is the impact of reducing the HANA thread limit?
  • How reducing threads improves performance and reducing CPU usage?
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers