I've been thinking about this a lot recently, basically to find out which
procedures get run, and how often, and how long they take.
Using external tables as a log table is one idea, and it's outside of
transaction context, so info won't be removed of a rollback happens.

Then, you could build a small tool that analyses the external tables, cleans
them as necessary, and derives whatever info you need.

Nige.

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]On Behalf Of Jiri Cincura
> Sent: Thursday, 23 March 2006 10:44 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Monitoring FB
>
>
> Hi,
>
> is there any command line utility, which show the (ultimate)
> info about
> the server/database (i.e. count of queries (in last x minutes or now
> running), memory usage, etc.)?
>
> Or something like that.
>
> --
> Jiri Cincura
> http://www.cincura.net/
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> __________ NOD32 1.1454 (20060321) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>