Hi guys,

I am running SS FB 3.0.4 x64 in Windows 10 x64 with 16GB RAM.

Database properties
================
ODS Version 12
Page size 16384
Pages 437728
Size on disk 6.68GB
Page buffers 10240
Read only false
 
Settings
========
Dialect 3
Default character set NONE
Sweep interval 20000
Forced writes

Database alias in databases.conf file
=============================
my_dba = C:\Dba\my_dba.fdb
{
    FileSystemCacheThreshold = 2M
    LockMemSize = 16M
    LockHashSlots = 30011
    TempCacheLimit = 2048M
    TempBlockSize = 2M
    DefaultDbCachePages = 65536
}

I ran a query with flamerobin, this is the statistic result :
=========================================
46220441 fetches, 17965 marks, 172471 reads, 82 writes.
8847 inserts, 0 updates, 0 deletes, 15730299 index, 8847 seq.
Delta memory: 4206064 bytes.
G_TMP: 8847 inserts.
Total execution time: 52.434s
Script execution finished.

On Windows Task Manager, Firebird Server took 236MB RAM, max.

If not mistaken, Page Cache Size should be
Page Size x DefaultDbCachePages = 16384 x 65536 = ~ 1GB

Why Firebird server only took 236 MB RAM ? Is this normal or something missed here ?

Thanks & regards,
Anto