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