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.

You might find further information about this tool on Thomas Steinmaurer's blog.

Go to the downloads page to download the application.