Firebird Transaction Statistic Logger 1.1

By Upscene Productions

Freeware 16 Feb 2010

In category

Database Tools > Interbase, Firebird, Yaffil > Other


Firebird Transaction Statistic Logger (FTSL) is a Windows utility to log the following important transaction counters of a Firebird database:
  • Oldest Transaction (OIT)
  • Oldest Active Transaction (OAT)
  • Oldest Snapshot Transaction (OST)
  • Next Transaction (NT).
This will allow you to track down how your or other applications are using transactions in a Firebird database over a period of time. You will be able to analyze when e.g. the gap between OIT/ OAT/ NT got bigger and bigger, thus suffering from bad performance. You also might be able to tell whether a client application has a poor transaction management strategy in place or not.

These statistics can be obtained via a simple gstat.exe -h call as well, but you always get a snapshot of the current situation and not over a particular period of time. FTSL will do that.

FTSL allows you to log these numbers into a plain text file and/or a Firebird database with one simple table called LOG.

FTSL can run as an application with gimmicks like showing the counters and the gaps in a visualization component. You also can run FTSL as a Windows service per monitored database.


  • Status: Fully functional
  • Source: FW
  • Size: 1 234 058kB

Operating systems:

  • Windows Vista
  • Windows 2000
  • Windows 2003
  • Windows 7
  • Windows XP