Would the lack of Page Buffers cause a high number of "Page Faults" shown in
the Task Manager? Right now it's showing over 14 million. ouch

Thanks again,

Kevin





From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of simonbenedicic
Sent: Wednesday, April 14, 2010 9:56 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: DB Stats - Header Page







--- In firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com> , "Kevin Stanton"
<Kevin.Stanton@...> wrote:

>
> Page buffers -- I'll have to do some homework on that one.
>
>
>
> What should this setting be?
>
>
>

Hi,

It is for caching database pages in RAM (the setting you see in stats is
per-database setting).

http://www.firebirdsql.org/manual/gfix-buffers.html

If you are running Classic Server then this value should be small like 75,
for SuperServer should be larger like 8000 (but not too large - it can eat
all RAM on your server).
If it is set to 0, then it uses value from Firebird.conf ...

# ----------------------------
# Number of cached database pages
#
# This sets the number of pages from any one database that can be held
# in cache at once. If you increase this value, the engine will
# allocate more pages to the cache for every database. By default, the
# SuperServer allocates 2048 pages for each database and the classic
# allocates 75 pages per client connection per database.
#
# Type: integer
#
#DefaultDbCachePages = 2048

To find the best value for your database / server, you have to do a little
calculating and experimenting.

Regards,

Simon





[Non-text portions of this message have been removed]