A gap of 2000 seems extremely small to me, I have never seen a system
sluggish for this reason with such a small number. Are you sure it isn't
just general load on the terminal server / the functionality that is being
invoked at that time?

What is the size of the app:
1) No of users
2) Size of the DB
3) No of tables
4) What is the server processor doing when it is running slowly?
5) What is your config? Clients -> terminal Server -> Server?

JAC


<Michael.Vilhelmsen@...> wrote in message
news:avjodr+gf77@......

> Well.
>
> I.e. today the gab is after 4 hours somewhere around 2000.
>
> My software runs on a Terminal Server.
> The clients connects to this server, and works there.
> My customer has just moved to a new location.
>
> Therefor they have gotten a new router etc.
> After this the clients "falls off" every once in a while.
>
> When they fall off, whatever programs they had opend will be
> terminated.
>
> Could this termination couse the gab to grow ?
>
>
> Michael
>
> --- In ib-support@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> > At 09:07 AM 9/01/2003 +0000, you wrote:
> > >Hi
> > >
> > >I have a customer who complains about the speed dropping during the
> > >day.
> > >
> > >In the morning the transaktions (oldest transaction, oldest active,
> > >etc) are alike.
> > >
> > >But during the day the gab extends.
> > >The sweep function takes care of this, as far as I know. Correct ?
> >
> > Wrong.
> > A gap that grows larger and larger throughout the day is not a
> problem that
> > a sweep will fix.
> >
> >
> > >The default value for sweep is 20.000, correct ?
> > >
> > >Could I change that to i.e. 1.000 ?
> > >
> > >Would it affect the system in any way ?
> >
> > It would not help your problem. You need to find why the gap is
> getting
> > unreasonably large, and repair your software and/or provide some
> training
> > for users about abandoning their workstations with unfinished
> > work..probably both are pertinent to your problem.
> >
> > >If the sweep function kicks in, and no user is connected, will the
> > >gab then be somewhere between 0 and 1 ?
> >
> > No, the gap won't change until the "interesting" transaction is
> > resolved. If your software doesn't take care of it then nothing
> will,
> > except a server shutdown. Meanwhile, you have an ever-accumulating
> pile of
> > old record versions which won't be touched by housekeeping.
> >
> > heLen
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>