Hi all,

I've been asked to support a Firebird application currently running on
FB 1.5.0. It's being run on a dual processor Xeon 3.0Ghz with 1Gb
memory and Win 2k server.

Currently it's having performance issues where the server is ~50% of
the time running at 100% off one processor.

So far I've turned off Hyperthreading, set the CpuAffinityMask = 2 and
tried to use gfix to increase the cache buffers(Not sure if that worked).

Is there anything else I can do? Is it worth me upgrading to FB
1.5.4? Or even 2.0.1?

Can I log long running queries?

Are there any other settings that might help?

Regards,

Ben