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: [email protected]
[mailto:[email protected]]
Gesendet: Donnerstag, 14. April 2016 14:03
An: [email protected]
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.
