Hello Kevin,

> In the past few weeks one of our clients (FB 1.0.3) has started

experiencing

> severe (database operation, queries mostly) slowdown of our application

that

> seem random. It will occur for an hour and then disappear.
>
> One of the other symptoms, seems to be (so far) a "(SQL Server)" user

showing

> in IBExpert. Yes, the parentheses are included. We do not have any such

user in

> the database user list.

It's the "internal connection" for the "garbage collection" process.

> 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.
>
> My questions:
>
> 1) What is this "(SQL Server)" user that IBExpert shows intermittently?
> 2) What could be the cause of the slowdowns? Sweep?
> 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?

Sounds like you have some long running transaction open.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com