Subject Re: [firebird-support] sizing cache
Author Thomas Steinmaurer
> I'm looking at increasing the cache size of my system to improve
> performance but running into contradictory advice. (firebird 2.1.5 on
> centos)
> says "... You should not set the cache
> size to consume large part of your RAM...."
> The new firebird book (p231) says " ...The first broad-brush optimization
> you can try is to increase the default cache to a size that will occupy
> approximately two-thirds of available free RAM. If there isn't enough RAM
> installed, install more. ..."
> This is a VM with 8GB RAM, 4vCPU, with maybe 10 connections, running
> classic,
> T
> he book also (p231) says "use a monitoring tool to observe and record how
> reads
> and writes are satisfied from the cache" I've looked at several tools and
> n
> one seem to show this data, any suggestions what tool(s) to use here?

FB TraceManager gives you the Cache Hit Ratio via monitoring tables and
via the Trace API.

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.