Well this computer (server database) has only this database and is
exclusively used as a database server.

All connections are made by a Delphi XE2 DataSnap server application, all
them with SYSDBA user.

I logged as SYSDBA user when running the select statement.



Any other guess?



De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Thomas Steinmaurer
Enviada em: quarta-feira, 12 de setembro de 2012 12:36
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] mon$attachments versus fb_inet_server
processes

> Some strange things are occuring with my Firebird Classic 2.5.1 (Windows
> server 2008) right now:
>
>
>
> When I runs this statement (select count(*) from mon$attachments) it

returns

> 113 connections to me but then I count the number of fb_inet_server.exe
> running process I reach the number 220!

* MON$ATTACHMENTS is for a particular database. If you have not only one
database, the processes might be from connections to other databases.

* AFAIR, you won't see all attachments when querying the monitoring
tables with a Non-SYSDBA user.

Regards,
Thomas



_____

Nenhum vírus encontrado nessa mensagem.
Verificado por AVG - www.avgbrasil.com.br
Versão: 2012.0.2221 / Banco de dados de vírus: 2437/5264 - Data de
Lançamento: 09/12/12



[Non-text portions of this message have been removed]