You may want to try changing the garbage collection policy to 'cooperative' in firebird.conf and see if that makes a difference, that's how 1.5 used to do things. Don't forget to restart the server process.

FWIW
Best regards
Gary

----- Original Message -----
From: slalom91
To: firebird-support@yahoogroups.com
Sent: Monday, December 11, 2006 9:00 AM
Subject: [firebird-support] Firebird v2 CPU Pegged


Hello All,

I have upgraded to Firebird 2 (from 1.5.2) and am experiencing an issue
where the CPU on our server is maxing out at 100% and not being
released. The SCM shows that fbserver.exe is responsible.

The OS is Win XP Pro with 2GB RAM. Local Windows services accessing DB
on same box. The DB was located on a remote box but I moved it
troubleshooting this issue. This is a multi-threaded environment with
approximately 5 simultaneous users at all times.

I hope there are some config items that can be adjusted to address
this, because I am not finding any way to revert back to 1.5.2.

Thanks in Advance.

Phillip





[Non-text portions of this message have been removed]