Subject | A few questions..... |
---|---|
Author | Michael Vilhelmsen |
Post date | 2004-11-04T07:49:55Z |
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
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