Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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...

  • Do you think there is a context between the unsheduled requests and the heavy workload of the CPU?
  • What can i do to reduce the unscheduled requests/CPU-Workload?

asked 04 Jun '18, 08:11

pmiller's gravatar image

accept rate: 37%

closed 05 Jun '18, 03:00

... and what was the solution / root cause?

(07 Jun '18, 09:45) Vlad

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.

permanent link

answered 04 Jun '18, 10:28

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

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

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 04 Jun '18, 08:11

question was seen: 1,506 times

last updated: 07 Jun '18, 09:45