Subject Re: [firebird-support] Slow join with mon$ tables
Author Douglas Tosi
On Fri, Feb 20, 2009 at 10:16 AM, Dmitry Yemanov
<dimitr@...> wrote:
> Douglas Tosi wrote:
>> But 2.5 seems broken (Firebird-2.5.0.22983-0_x64).
>> mon$attachments display only the current_connection. I cannot see the
>> other 200 attachments.
>> Every attachment was made using sysdba. I should be able to view them.
>
> Weird. It was tested with 800 connections a couple of months ago and
> everything worked okay.

My mistake, sorry.
I was using "trusted authentication" on one end, which resulted a user
named "douglas". On the other end I was using plain old sysdba.
Confusing, I'd say, since both users have admin privileges.
But monitoring is alright.

btw, the good news is that indeed 2.5 consumes *a lot* less memory to
monitor 10K objects.

Thanks Dmitry,
--
Douglas Tosi
www.sinatica.com