Hello Thomas..
Database "D:\INTERBASE\IFLS.GDB" Database header page information: Flags 0 Generation 2939162 System Change Number 0 Page size 4096 ODS version 12.0 Oldest transaction 2893677 Oldest active 2929833 Oldest snapshot 2878316 Next transaction 2938824 Sequence number 0 Next attachment ID 87910 Implementation HW=Intel/i386 little-endian OS=Windows CC=MSVC Shadow count 0 Page buffers 0 Next header page 0 Database dialect 3 Creation date Mar 7, 2016 18:33:37 Attributes force write Variable header data: Sweep interval: 5000 *END* Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Donnerstag, 14. April 2016 14:03 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] How to interprete gstat-results > Hello @ll, > > > > 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? Please post an entire gstat -h output. -- With regards, Thomas Steinmaurer <http://www.upscene.com> http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.