When the SQL Anywhere Monitor is showing metrics for a single database on a SQL Anywhere server that is running 10 databases, it shows all the connections to all the databases as if they existed on that one database.

For example, the Monitor shows that database ddd001 on server ddd has 21 connections, but in reality it only has 3 connections:

alt text

Here is the reality; Foxhound shows that ddd001 has 3 connections:

alt text

Similarly, the Monitor shows ddd002 having (the same) 21 connections:

alt text

Foxhound shows ddd002 having 2 connections:

alt text

asked 28 Nov '12, 14:05

Breck%20Carter's gravatar image

Breck Carter
accept rate: 21%

Feels like someone is about to add a "why-the-other-monitor-is-better" tag:)

I'm indifferent, FWIW...

(28 Nov '12, 18:28) Volker Barth

This is a bug because the connections listed are for all connections to databases on the server you are monitoring. Thanks, Breck.

permanent link

answered 29 Nov '12, 11:26

PaulTonizzo%20%20SA%20tools's gravatar image

PaulTonizzo ...
accept rate: 31%

Your answer
toggle preview

Follow this question

By Email:

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



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:


question asked: 28 Nov '12, 14:05

question was seen: 1,107 times

last updated: 29 Nov '12, 11:26