On 9 Dec 2004 at 14:33, Kevin Herrmann wrote:

>There are many other things wrong with this customer's implementation,
>but this is so odd, I needed some feedback. I've been using Interbase
>and Firebird for 9+ years and have never seen this before. At first, I
>thought it might be the Sweep or something, but that's inconsistent
>with my experience.

Before FB, this user was unnamed and used to crash server if
somebody ask for connected users list.

>1) What is this "(SQL Server)" user that IBExpert shows
>intermittently?

This is sweep process (and may be garbage collector too as Martin
said).

>2) What could be the cause of the slowdowns? Sweep?

Yes. But automatic sweep is caused by wrong transaction patterns
AKA long-living transactions.

>3) What can I do to eliminate both? I know how to eliminate sweep,
>but seems like that's a problem, too. So I'd have to turn it on and
>off in batch process at night or something?

Commit transaction as soon as possible. Avoid XXXRetaining. Avoid
rollback.
--
SY, Dimitry Sibiryakov.