|
Home > Archive > MS SQL Server > January 2006 > Sleeping connections
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Sleeping connections
|
|
|
| Running Sql Server 2000, I have about 20 Sleeping connections "NT
Authority\System" with dbName=master.
What are these and how do I close them?
I think they are connections I was trying to make across my VPN with my Sql
Server Enterprise Manager that was having a hard time connecting or just
freezing and I had to kill the program.
Thanks,
Tom
| |
| John Bell 2006-01-30, 3:23 am |
| Hi
If these processes are no-longer talking to SQL Server they should
eventually be removed. You could try using KILL on them, this is detailed in
Books Online:
"Use KILL very carefully, especially when critical processes are running.
You cannot kill your own process. Other processes not to kill are:
AWAITING COMMAND
CHECKPOINT SLEEP
LAZY WRITER
LOCK MONITOR
SELECT
SIGNAL HANDLER"
John
"tshad" wrote:
> Running Sql Server 2000, I have about 20 Sleeping connections "NT
> Authority\System" with dbName=master.
>
> What are these and how do I close them?
>
> I think they are connections I was trying to make across my VPN with my Sql
> Server Enterprise Manager that was having a hard time connecting or just
> freezing and I had to kill the program.
>
> Thanks,
>
> Tom
>
>
>
|
|
|
|
|