CPU Usage MAXCPU 2
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
Why does the second database kernel Process not use any CPU Time?
Is this normal? (0:00 vs 195:23 seconds)
Markus Doehr replied
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