Database header page information:
Flags 0
Checksum 12345
Generation 715138
Page size 4096
ODS version 11.2
Oldest transaction 676463
Oldest active 676464
Oldest snapshot 662552
Next transaction 715100
Bumped transaction 1
Sequence number 0
Next attachment ID 3104
Implementation ID 16
Shadow count 0
Page buffers 130000
Next header page 0
Database dialect 3
Creation date May 9, 2014 21:03:42
Attributes
Variable header data:
Sweep interval: 0
*END*
This is after I did a manual sweep two hours ago.
-Josh
*Josh Hartmann*
Senior Engineer
COMPUtek Dental Systems
P: 970-224-4022
F: 970-224-4001
*From:* firebird-support@yahoogroups.com [mailto:
firebird-support@yahoogroups.com]
*Sent:* Tue., May. 13, 2014 3:39 PM
*To:* firebird-support@yahoogroups.com
*Subject:* RE: [firebird-support] Cache Performance Options
> Set,
> There is a large gap because I turned off auto sweeping. I disabled it
because
> when it was sweeping, it was killing performance even more. Previous to
the
> 2.5.2 update, it was also using all the memory and causing the server to
swap
> every time it did a sweep (20,000 transactions). Right now, I have it
sweeping
> once during their lunch downtime and again at the end of the day. It is
faster
> than before the 2.5.2 update, but still not fast.
Please provide the gstat header details for the database.
Also you should also have a look at the SysInternals RAMMap tool, it
provides insight in the application and system process which are consuming
memory. This includes the OS file cache, which is the source of many
problems with x64 version of Windows, and the reason why the amount of page
cache activity is so high.
Sean
[Non-text portions of this message have been removed]
