MaxDB / MAXCPUS

[CLOEFFLER]

Hi Everyone,

after moving the productive ERP system to a new HP box we

are experiencing bad performance (that what users "feel").

The new box is a HP server making use of Intel E5-4640 CPUs

which means 4 sockets with 8 cores each and Hyperthreading

activate. This makes a least 64 CPU showing up in Windows

Task Manager.

We configured MaxDB using 64 GB RAM (total 128 GB) and

set MAXCPU = 24. On the system there is a SAP central

instance running (ERP 6.0 EHP4).

But still we can see that CPU cores will not be used more

than 10 to 15 % all over the day. So it seems the server is

bored.

What would be suggestion to set MAXCPU? Is it relevant

in a performance context?

Thanks a lot in advance.

Kind Regards,

Carsten

[yashwanthkumar_kethineed]

Hello Carsten,

Here's some usefull information about the MAXCPU configuration that might answer your question -

The database parameter MaxCPUs (MAXCPU) is used to notify the database kernel of the number of CPUs from the threads that can be used by the database. However, this configuration affects only UKTs that contain user tasks. Other threads access an unlimited number of CPUs, even if the value of MaxCPUs (MAXCPU) is reduced.

If you are a SAP Customer, more information can be found in SAP Note - 936058 - Question 12
12. Which factors determine how the MaxCPUs (MAXCPU) database parameter is set?

Best Regards,

Yashwanth