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.

When the SQL Anywhere Monitor 12.0.1.3810 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
26.6k418576824
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 ...
516310
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

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:

×30

question asked: 28 Nov '12, 14:05

question was seen: 979 times

last updated: 29 Nov '12, 11:26