|Subject||Re: [firebird-support] How to interprete gstat-results|
> Hello @ll,Please post an entire gstat -h output.
> we are using firebird 3.0 RC2 and have some questions about open
> transactions. (Clients connect over odbc) The gstat output gives 70000
> transactions between the oldest and the current transaction, if we look into
> the monitoring table, we see only 10 transactions. The "oldest one" we
> cannot find in this table. What is the oldest transaction and which roll
> does the garbage collector play? If we have many open transactions, the
> performance is bad. What role plays the attachments? What is the best way to
> check the performance bottleneck in such cases?
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.