Subject Re: Firebird.conf FileSystemCacheSize, Where am I going wrong?
Author hvlad
--- In firebird-support@yahoogroups.com, Anderson Farias wrote:
>
> Hi Vlad,
> > How much RAM do you have and what build (32 or 64 bit) of Firebird do you use ?
>
> The case I've seem was:
> * Windows Server 2008 R2 (64bit, as far as I remember)* Firebird 1.5.6 Classic (32bit, of course)
>
> After some time server shows almost 100% of memory usage (8Gb).

32-bit GetSystemFileCacheSize API is not able to get value of 8GB RAM available (it can't fit into 4-byte long variable). Therefore Firebird didn't set the FS cache size limit.

Note, there is no message at firebird.log about GetSystemFileCacheSize failure because every attachment in Classic Server will log it again and again and there is no way to disable it.

Regards,
Vlad

PS It is very easy to write a little utility which will show and set FS cache size limit ;)