cancel
Showing results for 
Search instead for 
Did you mean: 

What is maxdb doing with many dbmsrc -sdbstarter processes

DieterLorenz
Active Participant
0 Kudos

1 month ago we have the same problem with the 7.9.08.08 maxdb. I increase the prozessor parameter from 1 to 2. After that we have no problem with many (80 to 95) dbmsrc -sdbstarter processes. But we have only a high load if user are working - and if many batch jobs are running.

Now the problem occours again. Processor load is up to 85 % of a 4 processor machine.

How can I find out what maxdb is doing at the moment ? Index are all ok.

Thanks a lot

Accepted Solutions (1)

Accepted Solutions (1)

DieterLorenz
Active Participant
0 Kudos

I deactivate the automatic update stats in maxdb and delete the jobs in db13 temporary. The massive load from dbmsrv is gone. I monitor the system for the next days ...

Answers (3)

Answers (3)

DieterLorenz
Active Participant
0 Kudos

I think the problem is many locks in detail: row_share, row_exclusive in dbacockpit. MaxSQLLocks is 1500000. quite enough !

prithvirajr
Contributor
0 Kudos

Hi

Please check the sap note 1546311 - Increase in dbmsrv processes on the database server

if that helps here

Regards,

Prithviraj.

JamesZ
Advisor
Advisor
0 Kudos

yes note 1546311 seems helpful, please also show me with the os "ps" result for dbmsrv.

DieterLorenz
Active Participant
0 Kudos

Yes so many dbmsrv and the high load.

On the development system there is only one kernel and one dbmsrv running in the processes.

This is running on production - looks not he have a lot to do !

ID UKT UNIX TASK APPL Current Timeout/ Region Wait
tid type pid state Priority cnt try item
T8 9 21708 User 30994 Vwait 0 378688676(s)
T9 9 21708 User 30287 Vwait 0 378688676(s)
T10 9 21708 User 29590 Vwait 0 378688676(s)
T11 8 21707 User 2970 Vwait 0 382410554(s)
T13 8 21707 User 3509 Vwait 0 382410554(s)
T15 9 21708 User 3587 Vwait 0 378688676(s)
T16 8 21707 User 4566 Vwait 0 382410554(s)
T17 8 21707 User 28510 Vwait 0 382410554(s)
T19 9 21708 User 30307 Vwait 0 378688676(s)
T20 9 21708 User 14971 Vwait 0 378688676(s)
T22 8 21707 User 12046 JobWait UpdStt 0 382410554(s)
T23 8 21707 User 14568 Vwait 0 382410554(s)
T28 9 21708 User 28626 Vwait 0 378688676(s)
T29 8 21707 User 2962 Vwait 0 382410554(s)
T32 9 21708 User 29614 Vwait 0 378688676(s)
T34 9 21708 User 12107 Vwait 0 378688676(s)
T35 8 21707 User 1785 Vwait 0 382410554(s)
T39 9 21708 User 3675 Vwait 0 378688676(s)
T41 9 21708 User 30360 Vwait 0 378688676(s)
T42 8 21707 User 3138 Vwait 0 382410554(s)
T43 9 21708 User 29837 Vwait 0 378688676(s)
T44 8 21707 User 14735 Vwait 0 382410554(s)
T45 8 21707 User 2458 Vwait 0 382410554(s)
T46 8 21707 User 28615 Vwait 0 382410554(s)
T47 8 21707 User 14745 Vwait 0 382410554(s)
T48 9 21708 User 24504 Vwait 0 378688676(s)
T51 9 21708 User 23823 Vwait 0 378688676(s)
T54 9 21708 User 30800 Vwait 0 378688676(s)
T55 8 21707 User 2008 Vwait 0 382410554(s)
T59 9 21708 User 25484 Vwait 0 378688676(s)
T60 8 21707 User 2888 Vwait 0 382410554(s)
T61 8 21707 User 29598 Vwait 0 382410554(s)
T62 9 21708 User 14766 Vwait 0 378688676(s)
T63 8 21707 User 12077 Vwait 0 382410554(s)
T64 8 21707 User 22777 Vwait 0 382410554(s)
T65 9 21708 User 23116 Vwait 0 378688676(s)
T66 8 21707 User 31001 Vwait 0 382410554(s)
T67 8 21707 User 3206 Vwait 0 382410554(s)
T69 9 21708 User 30454 Vwait 0 378688676(s)
T70 8 21707 User 3577 Vwait 0 382410554(s)
T71 9 21708 User 28687 Vwait 0 378688676(s)
T72 9 21708 User 30608 Vwait 0 378688676(s)
T75 8 21707 User 14574 Vwait 0 382410554(s)
T76 8 21707 User 14756 Vwait 0 382410554(s)
T78 9 21708 User 23815 Vwait 0 378688676(s)
T81 9 21708 User 14918 Vwait 0 378688676(s)
T82 9 21708 User 15612 Vwait 0 378688676(s)
T84 9 21708 User 30143 Vwait 0 378688676(s)
T85 9 21708 User 24513 Vwait 0 378688676(s)
T86 8 21707 User 24465 Vwait 0 382410554(s)
T87 8 21707 User 22768 Vwait 0 382410554(s)
T88 9 21708 User 29007 Vwait 0 378688676(s)
T90 8 21707 User 28523 Vwait 0 382410554(s)
T93 9 21708 User 30134 Vwait 0 378688676(s)
T98 8 21707 User 23097 Vwait 0 382410554(s)
T100 9 21708 User 23662 IO Wait (R) 0 19 378688676(s)
T106 9 21708 User 28694 Vwait 0 378688676(s)
T107 8 21707 User 4573 Vwait 0 382410554(s)
T148 9 21708 User 23326 Vwait 0 378688676(s)
T149 9 21708 User 23189 Vwait 0 378688676(s)
T150 9 21708 User 23808 Vwait 0 378688676(s)
T151 8 21707 User 2602 Vwait 0 382410554(s)
T153 9 21708 User 29197 Vwait 0 378688676(s)
T154 9 21708 User 14818 Vwait 0 378688676(s)
T155 9 21708 User 3683 Vwait 0 378688676(s)
T157 8 21707 User 14825 Vwait 0 382410554(s)
T159 9 21708 User 29773 Vwait 0 378688676(s)
T160 9 21708 User 3689 Vwait 0 378688676(s)
T161 9 21708 User 25732 Vwait 0 378688676(s)
T165 8 21707 User 2001 Vwait 0 382410554(s)
T166 8 21707 User 29830 Vwait 0 382410554(s)
T167 8 21707 User 28274 Vwait 0 382410554(s)
T168 8 21707 User 20266 Vwait 0 382410554(s)
T171 9 21708 User 29230 Vwait 0 378688676(s)
T172 8 21707 User 30300 Vwait 0 382410554(s)
T173 9 21708 User 28677 Vwait 0 378688676(s)
T174 8 21707 User 2219 Vwait 0 382410554(s)
T175 9 21708 User 29000 Vwait 0 378688676(s)
T176 8 21707 User 22837 Vwait 0 382410554(s)
T178 8 21707 User 28516 Vwait 0 382410554(s)
T179 8 21707 User 2018 Vwait 0 382410554(s)
T180 9 21708 User 24749 Vwait 0 378688676(s)
T181 9 21708 User 30275 Vwait 0 378688676(s)
T182 8 21707 User 2239 Vwait 0 382410554(s)
T183 8 21707 User 22512 Vwait 0 382410554(s)
T184 9 21708 User 28705 Vwait 0 378688676(s)
T186 9 21708 User 31008 Vwait 0 378688676(s)
T187 8 21707 User 23106 Vwait 0 382410554(s)
T188 8 21707 User 28502 Vwait 0 382410554(s)
T192 9 21708 User 28796 Vwait 0 378688676(s)
T194 9 21708 User 15469 Vwait 0 378688676(s)
T205 9 21708 User 17006 Vwait 0 378688676(s)
T207 9 21708 User 29605 Vwait 0 378688676(s)
T208 4 21703 UpdStat IO Wait (R) 0 2 146477472(s)
T209 4 21703 UpdStat IO Wait (R) 0 8 146477472(s)

this is running on developement system: (DB version is the newest 7.9)

ID UKT UNIX TASK APPL Current Timeout Region Wait UKT
tid type pid state Priority cnt try item count

Console command finished (2018-03-14 14:16:42).

JamesZ
Advisor
Advisor
0 Kudos

Hi,

Are you care about what maxdb kernel is doing or why so many dbmsrv? what kind of the problem you meant?

Following os command shows us what maxdb kernel is doing:


x_cons show active

Best regards,
James