on 2013 Jul 23 3:20 PM
We have a version 12 DB on solaris that is now showing a higher than normal CPU. As in 60% versus the normal 5-10%. What can I do to diagnose this? I have looked at some of the system procedures and none of them seem to provide what I need. I want to see if there is a connection that is pinning the CPU or connection that has been open and executing a query or update for a long time. This is in a production environment so I don't want to bring down the DB.
Request clarification before answering.
Try the SQL Anywhere Monitor (which comes in the box), or Foxhound...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
52 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.