At 11:29 PM 16/03/2005 +0000, you wrote:

>Yes, Processing at 100%. Windows 2000server. Not sure of the
>mainboard model. SATA from the board.
>
>I was thinking of recommending our client get something like a Dell
>PowerEdge server with;
>
>* 2 or 4 Xenon 3.6Mhz CPU's - but I'm not sure more than 1 CPU with
>make much of a difference with Firebird 1.5?

With Win2k and Fb Superserver, the CPU affinity *must* be set to a single
CPU. With the Classic server there will be load-spreading benefits from
mutliple CPUs.

>* 2-8Gb ECC RAM - but I'm not sure how much more RAM firebird 1.5 can
>benefit from?

Firebird loves RAM.

>Note Also; firebird.conf has all defaults.
>PageSize=8192. Buffers=65535

Those are not firebird.conf defaults, they are database settings and they
are not defaults. The Buffers default for SS is 2048, for Classic it is
75. Knock the buffers back to 8K pages and, if you like, try increasing
the page size to 16K next time you restore from a backup..

./hb