> I tried Helen's suggestion about using a single port, but have just
> had this happen again, first time in 3 weeks. I stopped and started
> FB from the Control Panel without problems and the fault was gone
> again.
>
> How do you tell if a sweep is occuring? Could this be causing this
> apparent (99% CPU useage) effect? I think(?) that clients are still
> able to log on (slowly).
>
> Thanks,
> Steve
>

Try this. Turn sweep off - set it to 0 and it will be left for you to do
manually.
Now watch the performance and check the statistics regularly.
If the performance remains good and the CPU does not go thru this useage
pattern, then it was probably sweep causing it. But the real issue is why is
sweep being triggered every 3 weeks? I can only suspect that your client
application is not handling transactions correctly. Read up on the effect of
autocommit transactions or the effect of not doing a hard commit regularly.
I've said this before, that seep might be a nice bit of housekeeping to do
occasionaly outside your backup/restore cycle but if it's left to the
default 20,000 and your application is moving transactions along nicely,
this default is never reached. My applications never trigger sweep. I don't
do it manually either.
Alan