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

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