"Macma" ...

> Hi,
>
> I'm using Firebird SS 1.5.5 (default settings) on Windows Server 2003 R2
> PL Standard Edition with SP2. HP Proliant DL180 G5 with Intel Xeon E5420
> and 4 GB RAM, RAID 1+0 on SmartArray P400.

32-bit OS can't use all of your 4GB RAM

> I'm using 5 database and on every database I set Page Buffers to maximum
> 65535. So it's 65535 * 8k (page size) = 512 MB for each database. It's
> look like I need 2560 MB for all database witch gave me some margin for
> sorting and others operation.
>
> Bud when I try to connect to this databases I get error "internal gds
> software consistency check (cannot start thread)". In firebird log i see:
>
> SYDELSERVER (Server) Wed Jul 30 13:03:04 2008
> Database: D:\SYDEL\DANE\BAZYT\TURZADZENIA.FDB
> Allocated 13101 page buffers of 32767 requested
>
> SYDELSERVER (Server) Wed Jul 30 13:03:04 2008
> Database: D:\SYDEL\DANE\BAZYT\TURZADZENIA.FDB
> internal gds software consistency check (cannot start thread)
>
> It's looks like firebird can't allocate more than 2GB of RAM. When I

As any other 32-bit application

> decrease Page Buffers to lower values so my fb memory usage is below 2GB
> every thing look fine bud sometimes I get error that I have not enough
> memory for sort operation but I see that I have at least 1,5 GB free RAM
> and a lot of disc space.
>
> I switch to firebird 2.1.1.17910 and I had the same problem.
>
> I try to keep pages in memory (as more as I can) because disc operation
> is my only bottleneck.
>
> What could be the reason of this behavior ? Any help appreciated.

Try FB x64 edition. On x64 OS of course

Regards,
Vlad