I don't know if anyone has mentioned this already, but there can be issues with the network card. Check your NIC settings on the server and make sure the communication speed is SET to its real speed e.g. 10/100 rather than auto. Not all cards have this setting though, it is normally under the advanced tab.
Russ -----Original Message----- From: Rick Root [mailto:[email protected]] Sent: 02 December 2010 13:43 To: cf-talk Subject: Re: Diagnosing DB / CF problem So, There is a thread on one of my CF instances that has been hung for like 3 hours now... like the others I've mentioned, it's frozen on a SQL Server operation: The top of the stack trace is here: http://cfm.pastebin.com/9WkKuELc As with the others, the query is a perfectly normal query that runs hundreds or thousands of times per hour (this site processes about 25,000 CF rquests per hour during the night hours). So I ran sp_who <loginname> on SQL server and there's no sign of any hung threads... so I think it's safe to say that SQL Server completed processing of the request, and somehow, Coldfusion failed to receive the result - perhaps due to a network problem... I am at a loss on how to resolve this issue. Networking is *WAY* out of my league. I don't even know what an "unmanaged switch" is, nor do I really have any idea what the network topography in the data center is like... Rick > On Sun, Nov 28, 2010 at 8:42 PM, Dan Crouch <[email protected]> wrote: >> >> I see similar things like that happen sometimes and SeeFusion won't kill them either. In those cases, many times what I can do is run an sp_who on the database and look for the offending query, use a dbcc inputbuffer(processid) if need be and then kill that process id. Most of the time, that will allow me to kill the hung thread in SeeFusion so that no restart is needed. I haven't tried FusionReactor so I am not sure it works the same way, but the problem is very similar to what I have seen, just viewed it through SeeFusion instead. I dont know why it happens, something just seems to temporarily have gotten stuck on stupid. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
