Subject A few questions.....
Author Michael Vilhelmsen
Hi

Just a few questions.

First.
Last night I was about to do some updates to our own DB.
When I connected I kept seing two connected users. Myself and someone
else.
This happens every once in a while, because someone forgets to turn
off their PC.
But last night, when I looked at connected users there was:

SYSDBA (Me ;-) )
(SQL Server)

I have never seen a user connected called (SQL Server).
And there and non users created called this.

Anyone knows what that is ?


I could suspect it to be "sweep".



Second.
When sweep is set to 20.000 when does the DB decides to sweep ?
When reaching 20.000+ ?
When the users disconnects ?
Other ?


I think thats it for now ...


Michael