This is a newly installed HANA instance that we were going to hook up to a test region. After being up and running for a few days the overall performance went to crap. Everything is slow - ie: viewing the overview screen in Eclipse takes 3+ minutes. When it finally loads it is showing very high CPU usage:
However, we can watch the server while we wait and it isn't using any CPU at all... It is sitting at 99% idle!
I can't find anything in the service marketplace that matches this scenario... Any ideas where I can start? I am waiting on our Basis team to raise an incident but thought I would ask here in the meantime in case anyone has seen this before.
The top output doesn't show the processes or the actual hostname you're looking at.
So right now, I'd guess you're actually looking at a different host.
Have you checked the system LOAD graph? Does it show any CPU spikes?
The point that the HANA studio screen returns slowly when it reports a extremely high CPU load is at least consistent.
Do you have a grasp on what queries ran during the respective timeframe?