Subject Re: [firebird-support] Database level sql monitor?
Author Alexandre Benson Smith
Harriv wrote:
> Many component sets have built-in SQL monitor tool, but is there
> database level SQL monitor capabilities in Firebird? I'd like to log
> what some third party software do.

If you use FB 2.1 you could use the monitoring tables for this,

Just a reminder...
Monitoring tables are a snapshot on a given moment, so you have no way
to catch all statements executed, you will get as much as you ask for,
even if you ask every 0.5 seconds you will miss some quick queries.

There are some proxies that intercept all the client calls, perhaps it's
what you are after, IIRC fbproxy is one of them.

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil