> >What is the size of the database pages? > >Have you checked the DB level Page Cache setting (the DB can have a > different value from the config)? > >How much RAM is available for the VM? > > Sean, theres 13gb of RAM, and no db with specific settings > Page size is 16k
Ok, so a single database you are not "over subscribing" RAM. > >*EACH DATABASE* will be consuming up to (50000 * page size) on cache. > >Why do you set DefaultDbCachePages so high???? The Firebird server > >needs RAM for more things than just the cache. > > Helen, pages are high only because I copied the suggested values from the > config at https://ib-aid.com/br/optimized-firebird-configuration/ > Since it is the first time we're using superserver we went for these > recommended settings. > Isn't the page cache shared in this mode on firebird 3 (50000 pages for all > dbs) ? No, *DB* Page Cache is per database. How many databases are you hosting on the system?