Subject Re: Update: CPU Pegged on Firebird v2
Author slalom91
I have identified the application that was holding a transaction
handle open and have corrected it.

Question:

How would that have affected or caused the behavior I was
experiencing with v2? My sweep interval is set to 0 and I had tried
using each of the possible options for the garbage collector?

New database statistics info:

Database header page information:
Flags 0
Checksum 12345
Generation 377780
Page size 4096
ODS version 10.1
Oldest transaction 9677
Oldest active 377749
Oldest snapshot 377749
Next transaction 377773
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Dec 11, 2006 12:29:47
Attributes no reserve

Variable header data:
Sweep interval: 0
*END*