Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scullee
Posting Yak Master
103 Posts |
 Posted - 2005-09-18 : 20:17:07
|
| We have a problem with a group of connections that cannot be killed without restarting SQL Server.Due to a limitation with a system we work with, we had to implement calls to a database using a com object. The whole process has whiskers on it but there is not much we cant do. I tried using a linked server but it didnt work :(What happens is that the sql server calls the com object that calls the other db. When an error occurs in the other db, it "breaks" the com object and the call never seems to return. I have stepped through it and the call just locks up and doesnt return any error so there is not much i can do with error checking. The problem occurs because these errors tie up entries in our connection pool that are never released. We can fix it with a restart of the connection pool in our application but the rouge connections are still left when i run sp_who. I have tried "kill" to get rid of the processes but they just stay in "killed/rollback" state and never go away.Does sql have something like a kill -9 to force a kill on the connections? They arent inside a transaction so it shouldnt have to roll anything back. We currently have over 50 connections in this status that i just cant get rid of. |
|
|
scullee
Posting Yak Master
103 Posts |
Posted - 2005-09-19 : 23:10:54
|
| Bump, any ideas?The connections are still sitting in "killed / rollback" :( |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-19 : 23:26:12
|
| restart the server (but be cautious, coz you might experience this too...http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55329)then check what does the com do? post the idea here and we might justhave some alternative solution for that--------------------keeping it simple... |
|
|
|
|
|
|
Connections That Just Wont Die