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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Defunc process in SQL Server 2000

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?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-01-06 : 14:34:21
What does DBCC INPUTBUFFER(spidNoGoesHere) show for these?

Tara Kizer
aka tduggan
Go to Top of Page

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 Kizer
aka tduggan

Go to Top of Page

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?

Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -