Michael Vilhelmsen wrote:

>
>
> I have a theory ...
>
> This customer with the problem loves to do all sorts of statistical
> reports all the time. More than every other customer we have.
>
> Could it be, that someone is doing something in the morning, and
> thereby having a long running transaction - This will cause the gab
> between OAT and NT to grow during the day.
>
> Then at nigth they have to do there daily rutine, which is writing
> some report, updating some fields etc.
>
> To do this, they have to switch programs. And thereby they will close
> every open query and commit the work.
>
> This will cause the sweep to kick in (sinse the gab is more than 20.000).
> At the same time the users starts the daily rutine, and makes new
> transactions - At this time the memory consumption is at its peak, the
> sweep is running and everybody complains about speed. And someone
> can't connect due to the fact that all 2 Gb of RAM has been used.
>
> Is this case - What will happed if I disable the sweep - and manually
> make a sweep at nigth (just after the backup) ?
>
> Michael
>

In my opinion your theory looks very good.Just give it a try.I think
that you cannot make things being worse just by setting sweep interval
to zero.

Anybody comments ?


Regards
Boguslaw