Hi, what todo when the the databaseserver (Sybase 16 EBF 2344) is using up to 100 % of 2CPU with total of 32cores multiprogramming-level is off and at 96 (calculating 3*32 cores) i wachted into the performance counter for unscheduled request. They are frequently over 5 somtimes over 15 (for 2-3 Seconds) So i think the databaseserver is permanently busy...
asked 04 Jun '18, 08:11 pmiller |
The question has been closed for the following reason "Problem solved, it was an internal organizational problem" by pmiller 05 Jun '18, 03:00
When the server-level UnschReq property is high (e.g., 5), what are the values of these other properties? server-level ActiveReq connection-level ReqStatus; e.g., how many are Executing, Idle, Unscheduled, BlockedIO, BlockedContention, BlockedLock Also have a look at how fast the connection-level ApproximateCPUTime is increasing... there may be a runaway connection stealing all the cycles. If you jack up MultiProgrammingLevel to, for example, 200 and the UnschReq remains high, then it may be some kind of contention among connections. CALL sa_server_option ( 'AutoMultiProgrammingLevel', 'NO' ); CALL sa_server_option ( 'MaxMultiProgrammingLevel', '200' ); CALL sa_server_option ( 'CurrentMultiProgrammingLevel', '200' ); IMO, however, Foxhound will save you a lot of time :) See the White Paper here. answered 04 Jun '18, 10:28 Breck Carter i always see nice screenshots of foxhound but have some toubles to setup it. So I continued to use the system functions, no so clear and easy but i'll give foxhound a new try.
(05 Jun '18, 02:42)
pmiller
Replies hidden
I'm sure Breck is willing and able to help to setup his product:)
(05 Jun '18, 03:09)
Volker Barth
|
... and what was the solution / root cause?