Subject | Re: Sweep question causing cpu spikes |
---|---|
Author | javakqj |
Post date | 2009-07-17T15:40:24Z |
Thanks for the reply.
But how would I explain the changes in the total versions for the table? Who is changing them ? Any thoughts.
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.
>