Subject Re: [firebird-support] FB GBK and CPU Usage
Author Si Carter
Hi

On Wed, Oct 15, 2008 at 4:47 PM, Andrew Stuart
<Andrew.Stuart@...> wrote:
> Hi
>
> I did a backup/restore etc and it cleared it down nicely
>
> But after 14 hours its back up to a gap of 27549
>
> What would be a "good" gap, I assume anything around 1-100 or something
> low heh
>
> And how high would be bad enough to think about doing a backup/restore
> again
>
> This is obviously all fire fighting till we get to the root of the
> issue, im trailing fb v2 atm too try and help figure out whats happening
>

Not sure if it will help you, a few years ago I wrote a program called
FBHook (https://sourceforge.net/projects/fbutils), this logs all calls
to fbclient.dll or gds32.dll. you could look at the log to see when a
transaction starts and ends and all the sql that is being sent for the
transaction. This is for fb v1.* only.

hih

Si Carter
http://www.tkdwords.co.uk