Subject | Re: [firebird-support] Database level sql monitor? |
---|---|
Author | Alexandre Benson Smith |
Post date | 2008-12-03T23:01:41Z |
Harriv wrote:
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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> Many component sets have built-in SQL monitor tool, but is thereIf you use FB 2.1 you could use the monitoring tables for this,
> database level SQL monitor capabilities in Firebird? I'd like to log
> what some third party software do.
>
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
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br