The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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
22.3k9129262
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
26.6k418575824
accept rate: 21%

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:

×9

question asked: 12 Feb '14, 17:34

question was seen: 2,363 times

last updated: 13 Feb '14, 08:48