The forum is currently being migrated to a new host. While the migration happens, the old server is still available. Once the new machine is ready, I will copy the database to the new machine. Feel free to ask and answer questions in the meantime.

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
24.4k9137290
accept rate: 40%

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
31.3k5036891010
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: 3,922 times

last updated: 13 Feb '14, 08:48