> A Client of ours is running on version 2.04 Classic server. There are 40 db's
> with about 50 users accessing them at the same time. It is Win Server 2008 64
> Bit, 20GB ram and quad core cpu. Every day we need to restart Firebird as it
> gets extremely slow for the users to connect, after the restart it is fine. I just
> want to know if there are any settings we can change or change the type of
> instance that they use.

You need to review the database header statistics for each of the databases as well as investigate fixes for the known 64 bit Windows issue of page cache degrading system performance (the OS allows the page cache to grow without end, causing significant OS page file reads/writes).


Sean