Question Re: Total CPU Usage 100 in Technology Q&A

Total CPU Usage 100

klausfreyburger — Tue, 25 Apr 2017 08:40:10 GMT

Hi all,

I am doing first steps with HXE 20 SP01. Same Hardware setup as in HXE 20 (VMware 12 GB RAM). Whereas 20 works fine, now 20 SP01 is very slow after a couple of minutes (without touching the system!). E.g. statement HDB info takes a minute to execute (it executes immedeatly right after database start). System monitor shows CPU usage of 100.

I deactivated statistics server (this saves ressources according to a HANA academy video). No improvement.

What else can I do?

Thanks, Klaus

Re: Total CPU Usage 100

Benny — Tue, 25 Apr 2017 09:16:14 GMT

How much memory does the computer have?

Re: Total CPU Usage 100

klausfreyburger — Tue, 25 Apr 2017 10:13:46 GMT

16 GB in total

Update: After DB is running for a while (without touching), CPU goes down. Maybe this was just an issue of startup...

Re: Total CPU Usage 100

allwyn_theodore — Tue, 25 Apr 2017 10:57:44 GMT

Hi Klaus,

Please share some additional information on this issue

CPU Usage Statistics
Tenant Containers, if any
OS Level - Process Thread Usage info (No. of Process and their consumption)

Besides SAP Note : 2100040 [FAQ: SAP HANA CPU] can help you out.

Re: Total CPU Usage 100

klausfreyburger — Tue, 25 Apr 2017 12:42:45 GMT

In the meantime CPU usage is normal. seemed to be a startup issue.

Re: Total CPU Usage 100

klausfreyburger — Thu, 04 May 2017 05:36:49 GMT

Update how this story went on: After upgrade of host to 32GB RAM (from 16GB) and VM to 24GB RAM (from 12GB) the HANA runs a lot better!!

Br Klaus