Subject Re: [firebird-support] dimensioning server RAM
Author Aage Johansen
On Tue, 27 Jan 2004 17:18:19 +0000 (UTC), Peppe Polpo wrote:

> according to which rules of thumb does one establish the right RAM qty of
> a FB server ?

<Page Size> * <No of Cache Pages> for each opened database (plus a small
fixed amount for the server).


> In my case, I need to run about 10 similar databases, each of which runs
> SPs that are both computation-heavy and disk-RW-heavy SPs.

Add together the numbers from above (<PS>*<NoCP>) for each concurrently
opened database.


Note that Fb now has the ability to use free RAM for sorting which makes it
difficult to estimate total RAM.


--
Aage J.