Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

CPU Usage MAXCPU 2

Hi there,

We are running MaxDB 7.6.05.09 64bit on an SLES 9 64bit.

MAXCPU is 2.

sdb 6978 0.0 0.0 108616 6120 ? Ssl Sep20 0:00 /sapdb/PF1/db/pgm/kernel PF1

sdb 6984 4.4 11.9 1887800 976996 ? Sl Sep20 195:23 /sapdb/PF1/db/pgm/kernel PF1

Question:

Why does the second database kernel Process not use any CPU Time?

Is this normal? (0:00 vs 195:23 seconds)

Regards

Manuel

replied

Yes.

MaxDB is a multi-THREADED database, you will see only one process but it has many threads. The fist process is just the "starter", it forks the second one which is then the actual database.

You can check the threads by using

ps -ef -L

To see what the database threads are doing, login as sqd<SID> and execute

x_cons <SID> sh ac 1

Markus

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question