--- In firebird-support@yahoogroups.com, "will.honor" <will.honor@...> wrote:

>
>
>
> --- In firebird-support@yahoogroups.com, Anderson Farias <peixedragao@> wrote:
> >
> > This "eating all memory problem" occurs with Firebird (and perhaps other software) on Win 2008 server ... This seems an OS issue...
> > MS has an article on it saying it should not happen on R2 updated versions of the OS, but, it happens...
> >
> > Anyway, a friend wrote me with a possible solution here:
> > http://community-old.wyse.com/forums/topic.php?id=143
> > Haven't tested yet though.
> >
> > Regards,Anderson
>
>
> Anderson,
> Thanks, I have been looking around and it seems that all the possible solutions are using the same api calls to do their work. I found the following and can confirm that it works.
>
> http://blogs.msdn.com/b/ntdebugging/archive/2007/11/27/too-much-cache.aspx
>
> http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e24ade0a-5efe-43c8-b9c3-5d0ecb2f39af&displaylang=en
>
> Given that the firebird config option FileSystemCacheSize should also be using this api call I am not sure why it does not work when these other solutions do. I wonder if this is a firebird bug?
>
>
> Regards,
> Will.
>

When looking in the source, the adjustFileSystemCacheSize() of Firebird uses the API function SetSystemFileCacheSize().

Have you installed the 64bit version of the server. I think that only the 64bit version calls the 64bit version of SetSystemFileCacheSize.

good luck
Christian

Good luck
Christian