Skip to Content
0
May 13, 2020 at 12:55 PM

HANA Express SP4 Poor performance

392 Views

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