cancel
Showing results for 
Search instead for 
Did you mean: 

How to tune Hana according to the machine hardware configuration

lindsay1161
Discoverer
0 Kudos

When installing Hana on a machine, how to config hana according to the machine hardware configuration?

Such as how many memory/cpu can Hana use, or how many memory/cpu can XSA/optional components use?

Example: if there are two machines, one has 128GB memory and another has 256GB memory. How can we tune the Hana parameter to get better performance according to the machine physical memory size?

Accepted Solutions (0)

Answers (2)

Answers (2)

lbreddemann
Active Contributor

The options to configure SAP HANA are explained in detail in the SAP HANA Administration guide.

For your example, when HANA gets installed to a host, the installation provides an option to limit the maximum memory usage target for the system or to not set a limitation. If no limitation is set, HANA assumes it can use early all memory of the system for itself.

That means, on a 128 GB system, it will try and grab the 128 GB and on the 256 GB system it will try to get the 256 GB (ok, that's very simplified, but you should get the idea).

As for CPUs, HANA will always try to allocate all CPUs that are not marked as not-to-use (either via the Linux configuration or the corresponding system parameters).

bryan_bingay
Participant
0 Kudos

Good, question. Just like Lars said, HANA is going to use everything it has to satisfy the request, memory and CPU. This means that if you have a user that runs a query it could consume all CPU's and memory. This could cause your HANA system to encounter an Out of memory event or become unresponsive because the CPUs are pegged at 100%. Take a look at the HANA administration guide Workload Management. Since HANA is an in memory DB it is crucial that you don't run out of memory or CPU.

Also see SAP KB 2222250 - FAQ: SAP HANA Workload Management.