Subject | Strange User connected to Database "(SQL Server)"; big slowdown |
---|---|
Author | Kevin Herrmann |
Post date | 2004-12-09T22:33:22Z |
Hello all,
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.
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?
Thanks,
=====
Kevin Herrmann
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.
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?
Thanks,
=====
Kevin Herrmann