Subject Re: Sweep question causing cpu spikes
Author javakqj
Thanks for the reply.

But how would I explain the changes in the total versions for the table? Who is changing them ? Any thoughts.



--- In firebird-support@yahoogroups.com, Dimitry Sibiryakov <sd@...> wrote:
>
> > I captured the gstat snapshots at the beginning of a 10 min interval and the next one at the time the spike occurs and verified whether the sweep ran or not. I am suspecting the sweep is causing the spike .
>
> Your stats are perfect, so you can forget about autosweep. It'll
> never run.
> Look for other reasons. Say, auto-refresh in grid or scheduled job.
>
> SY, SD.
>