Firebird Transaction Statistic Logger 1.1

In category

Database Tools > Interbase, Firebird, Yaffil > Other

Description

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.

Informations

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

Operating systems:

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

Downloads

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