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 |
geossl
Yak Posting Veteran
85 Posts |
Posted - 2006-01-06 : 07:11:20
|
Dear All, There are more than 10 defunc process in a SQL Server 2000 (SP3). The last access date is on October 2005 but the status is runnable. It seems that these processes are defunc. I have tried to kill them but it does not succeed. Any way to prevent this? Any remedy to kill them without reboot? Thanks. |
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-01-06 : 13:31:33
|
What are the spids involved? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-06 : 14:34:21
|
What does DBCC INPUTBUFFER(spidNoGoesHere) show for these?Tara Kizeraka tduggan |
|
|
geossl
Yak Posting Veteran
85 Posts |
Posted - 2006-01-08 : 22:56:13
|
By using DBCC INPUTBUFFER, the program calls a stored proc(sp_send_cdosysmail). which uses CDO to send email.quote: Originally posted by tkizer What does DBCC INPUTBUFFER(spidNoGoesHere) show for these?Tara Kizeraka tduggan
|
|
|
geossl
Yak Posting Veteran
85 Posts |
Posted - 2006-01-09 : 09:56:15
|
The spid seems to be ordinary id given to application. Moreover, the applications that had already had the handle of the connections have already exit. Why didn't these processes time out anyway?quote: Originally posted by mcrowley What are the spids involved?
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-01-09 : 12:58:39
|
My question was more to make sure that these are not system spids (spid < 50). It could be that the application has not closed their connections in the code. If this is a web application, it could be the connection pool, but connection pool connections will disconnect after 90 seconds of no use. |
|
|
|
|
|