Subject Re: [firebird-support] Re: fb 2.1 on Windows: how to use more RAM?
Author Stefan G. Weichinger
Am 28.08.2010 01:30, schrieb Svein Erling:

> Were these statistics taken from the database at a time when it was
> slow? I'm asking because it seems it might be the statistics from a
> freshly restored database, and statistics taken at a time when the
> database is responsive isn't anywhere near as useful as statistics
> taken when the database is slow. These statistics indicate that your
> transactions are well handled, but as I said - if it is taken at a
> time when the database behaves well, this might not be the entire
> truth.

This is another output, taken right now and from the DB while people are
working ...

Database header page information:
Flags 0
Checksum 12345
Generation 533500
Page size 16384
ODS version 11.1
Oldest transaction 288095
Oldest active 288096
Oldest snapshot 76544
Next transaction 501810
Bumped transaction 1
Sequence number 0
Next attachment ID 31683
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Aug 25, 2010 20:37:57

Variable header data:
Sweep interval: 20000

But it is GOOD if things are fine ... :-)

Would the "Process Explorer" from help me to findout
what leads to swapping?

Right now I see 1.24 GB swapped and only around the same amount of
physical RAM used (saturday is not full-load-day, only less users than
on weekdays).