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]