SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Defunc process in SQL Server 2000
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

geossl
Yak Posting Veteran

Macao
85 Posts

Posted - 01/06/2006 :  07:11:20  Show Profile  Reply with Quote
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 - 01/06/2006 :  13:31:33  Show Profile  Reply with Quote
What are the spids involved?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37287 Posts

Posted - 01/06/2006 :  14:34:21  Show Profile  Visit tkizer's Homepage  Reply with Quote
What does DBCC INPUTBUFFER(spidNoGoesHere) show for these?

Tara Kizer
aka tduggan
Go to Top of Page

geossl
Yak Posting Veteran

Macao
85 Posts

Posted - 01/08/2006 :  22:56:13  Show Profile  Reply with Quote
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

Macao
85 Posts

Posted - 01/09/2006 :  09:56:15  Show Profile  Reply with Quote
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?


Edited by - geossl on 01/09/2006 09:58:27
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 01/09/2006 :  12:58:39  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000