HANA Express SP4 Poor performance

[former_member667479]

Hi,

Recently our HANA express machine (virtual machine installation) started having poor performance issues.

All our XSA apps are running at the speed of snail and any thing involving a SQL query is taking too much time.

The server is soo slow that cockpit is not able to load itself.

a simple command "xs a" is having below values for time command

real    0m12.066s
user    0m3.570s
sys     0m0.291s 

A simple API to run select query on table and get its content is taking 25s to give the results and while debugging, the sql statement took 23s

The HANA express is at its latest version with all the OS patches updated too.

Any help is appreciated.

Thanks

[dvankempen]

You asked a question. Don't forget to mark the answer that helped you most as correct. Thanks! For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too. Thanks.

[former_member667479 · Accepted solution]

Hi,

the issue is fixed by adding the IP and hostname mapping in /etc/hosts file of the system.

As HANA XSA makes lot of internal calls to its webdispatcher and I assume either thoese calls are going to some proxy server or the DNS server is slow to resolve the hostname, the overall speed of any call got affected.

most probably issue was because of some network problem but adding the mapping to hosts file fixed it.

[dvankempen]

Interesting.

The system database nameserver listens to port 13 where as the (first) tenant database indexserver of the listens to port 15.

How come the HDI container is attached to the system database?

[former_member667479]

Its because we we did not mapped the space to tenat DB, so by default all the HDI containers will go to SYSTEMDB.

Also the issue is fixed.

[dvankempen]

OK. You mentioned "recently". I understand first the lights were green, now they are orange (or red). Sounds like you need to investigate what might have changed. Not possible from here.

A good place to start is the documentation

• SAP HANA Troubleshooting and Performance Analysis Guide

pointing to a guided answer and FAQ, for example (plus much more)

• https://gad5158842f.us2.hana.ondemand.com/dtp/viewer/#/tree/1623/actions/21021
• 2000000 - FAQ: SAP HANA Performance Optimization

Keep us posted about your findings.

Thx

[former_member667479]

thanks,.

this problem came 3 months backu too, then the system by itself came to normal after some time. Now again same issue is there.

[former_member667479]

one thing I found out, that sql connections on port 39013 are slow and 39015 are running ok.

unfortunatily app our xs a hdi containers are bounded to 39013 port

[dvankempen]

three questions:

1. I understand you have upgraded HXE to 128GB using a license from the SAP Store, correct? HXE is free up to 32GB.

2. Allocating all system resources of the host (16 CPU 128GB RAM) to the guest VM usually is not possible. Has an experienced SLES engineer looked at the host configuration, cf. Virtualization Best Practices?

• https://documentation.suse.com/sles/15-SP1/single-html/SLES-vt-best-practices/index.html

3. Considering there is only a single VM, any reason the software is not installed on the host directly? Virtualisation adds overhead.

[former_member667479]

1. Yes

2. Its not a VM installed on a host, by VM I mean a VM inside hypervisor.

3. Software is installed on host itself, sorry for confusing you with the word VM.

[dvankempen]

I understand you have upgraded HXE to 128GB using a license from the SAP Store, correct? HXE is free up to 32GB.

What server (host) are you running this VM on? RAM + CPU

How many VMs are running and how much resources are allocated to each?

[former_member667479]

Its a SLES 12 sp2, 128Gb 16 CPu, only this HANA SP4 machine is running on it.

[dvankempen]

Hi Himanshu,

You might want to start looking at resources. The default memory allocation for HANA + XSA used by cloud providers is 24GB. That might serve as an indication.

How much RAM have you allocated to the VM? How much RAM does the host have? No other VMs running? No other programs running on the host?

[former_member667479]

Hi dan,

I installed hana express via binary installation on a VM with 128 GB ram and 16 cpu. and applied the license too so full 128 GB is in use.

Checked the resources and everything is fine there.