Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

What are the most likely causes of spikes in CPU usage to 99% for dbsrv10.exe, or more recent versions of dbsrv*.exe for that matter? Thanks in advance.

asked 12 Feb '14, 17:34

BetterOffTed's gravatar image

BetterOffTed
46224
accept rate: 0%

2

I really like this type of question: I have a great server, I want that the server is performing as fast as it can, but why the hell is the CPU used for this? Now frankly: A high peek performance can only be achieved if the CPU is used. So you have two possibilities, your software has a bug doing nonsense things with the CPU or what is more likely the software is doing its work and yes it will utilize the CPU.

I would be more concerned if a database software would not be able to bring a CPU to 100% usage.

(13 Feb '14, 03:17) Martin

Any query that either does lots of computations (e.g. stored procedure execution) or iterates over lots of rows that are already in cache (i.e. does not require any I/O ... or the I/O read-ahead can stay ahead of the executing query) will cause the CPU to 'spike' to 100%. I.e. the server will execute full-tilt until either it needs to wait for I/O, blocks on a lock, blocks on a 'WAIT FOR ...' or similar statement, hits a sync point (waiting for the client to fetch or rows), or completes.

permanent link

answered 12 Feb '14, 19:02

Mark%20Culp's gravatar image

Mark Culp
25.0k10142298
accept rate: 41%

Try running a monitor, either the SQL Anywhere Monitor which ships with version 11.0.1 and later but works on version 10 databases, or Foxhound which works on Version 5.5 through 12 databases. I recommend the latter :)...

Foxhound

permanent link

answered 13 Feb '14, 08:48

Breck%20Carter's gravatar image

Breck Carter
32.5k5417271050
accept rate: 20%

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×10

question asked: 12 Feb '14, 17:34

question was seen: 4,867 times

last updated: 13 Feb '14, 08:48