Re: [firebird-support] how to keep history of statements per transaction?

2016-05-31 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]

Hi,

use Trace API - the basic variant with text output is included into 
Firebird.


If you need GUI and retrospective analysis, you can try HQbird (trial 
version of Standard is 14 days), it contains PerfMon tool with TraceAPI 
support


More details in HQbird Guide, page 66
http://ib-aid.com/download/docs/hqbird2016r1userguide.pdf

Regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com





Hi,

I'm looking for easy to use solution that can help me trace statements
executed inside every transaction and keep them until transaction is 
active.


Once it is closed(commit or rollback) statements are discarded.

I need this to be able to run on a production system in order to track
which code path leaves open transaction or keeps transaction open for
long time.

Any ideas how to make this?

--
Doychin Bondzhev
dSoft-Bulgaria Ltd.
PowerPro - billing & provisioning solution for Service providers
PowerStor - Warehouse & POS
http://www.dsoft-bg.com/
Mobile: +359888243116

[Non-text portions of this message have been removed]







[firebird-support] how to keep history of statements per transaction?

2016-05-31 Thread Doychin Bondzhev doyc...@dsoft-bg.com [firebird-support]
Hi,

I'm looking for easy to use solution that can help me trace statements 
executed inside every transaction and keep them until transaction is active.

Once it is closed(commit or rollback) statements are discarded.

I need this to be able to run on a production system in order to track 
which code path leaves open transaction or keeps transaction open for 
long time.

Any ideas how to make this?

-- 
Doychin Bondzhev
dSoft-Bulgaria Ltd.
PowerPro - billing & provisioning solution for Service providers
PowerStor - Warehouse & POS
http://www.dsoft-bg.com/
Mobile: +359888243116


[Non-text portions of this message have been removed]