Skip to Content
author's profile photo Former Member
Former Member

SQL Anywhere monitoring tools

We just had an incident at a customer's site Monday evening where a SQL Anywhere 12.0.1 database that had been running since February 15, 2015 suddenly started having performance issues. The entire system was not impacted but one critical area that sends data from our system to another system started to fall behind. This customer runs a 24x7 distribution center and I did not want to bring them down so we kept trying to figure out what was going on. Part of that was stopping and restarting the application that sends the data. That would help for a few minutes but messages would begin to back up again.

One thing we noticed is the database engine was consuming 80 to 90 percent of the CPU consistently which is not the behavior we normally see. The database engine runs on a VM computer by itself. No other applications are on this computer.

After a few hours of this, I decided to punt and asked them to allow us to stop our application and also the database engine.

After we restarted the database engine and our application, everything has been fine since.

The CPU usage of the database is now around 50 percent with spikes to 80 but then back down and sometimes even into the 20 percent range. This behavior is more what we are accustomed to seeing.

Anyway, my question is what kind of monitoring and troubleshooting tools are available (I'm aware of the monitor program that can be licensed) and what would be recommended?

Thank you

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 10, 2015 at 01:41 PM

    Have a look at the Foxhound 3 Database Monitor.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.