Hi - can anyone comment on these db stats - I guess the transaction id's are
not good with such a difference. The db is being abused somewhat with users not
logging out at night hence the sweep we run (I assume) is having little effect.
The consequence of all this is deteriorating perfomance that only a
backup/restore can fix.
Database "e:\s32031\heesdata\hees_64.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 17624180
Page size 8192
ODS version 11.2
Oldest transaction 12940759
Oldest active 12940760
Oldest snapshot 12940760
Next transaction 17616636
Bumped transaction 1
Sequence number 0
Next attachment ID 9643
Implementation ID 26
Shadow count 0
Page buffers 20000
Next header page 0
Database dialect 1
Creation date Jun 5, 2013 0:13:43
Attributes force write
Variable header data:
Sweep interval: 0
*END*
Regards
Roger
