Subject Re: [firebird-support] see connections or threads in firebird 2.5 Super Classic
Author Thomas Steinmaurer
> I have migrated some of my dbs to firebird 2.5 superserver from firebird 1.5 classic server.
>
> In the classic server, each connection open a new process using the inet linuz daemon.
> I could see how many connections I had to the DB using the top command or the ps aux command.
>
> Now in Firebird 2.5 super classic I have one process fb_smp_server and treads to handle every new connection of that process.
> Now I can't type ps aux or top to checknumber of process (connections in Fb 1.5) I have.
> How can I check that ?

Starting with Firebird 2.1, you can do that via the monitoring tables.
Connect to the database and execute:

select * from mon$attachments



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!