I ran into a problem in the past where queries were getting hung - queries that usually executed all the time without issue (and queries that I could copy and paste into analyzer and run just fine). It turned out to be SQL running out of memory and not being able to compile an execution plan. The root cause was us not using cfqueryparam in our queries - making SQL not use its cache effectively. No idea if your problem is similar - but theres my two cents!
On Sun, Nov 28, 2010 at 9:12 PM, Russ Michaels <[email protected]> wrote: > > well I can tell you one of the causes for hung requests, it is visitors > closing your page before the request is complete which leaves it in a hung > state as there is no where to send the response back to. Not sure if this > could cause a hung db request though, I wouldn't have thought so as that is > between cf and the db not the client, but I spose it is possible that CF > may > also hang the db request if it know sthe client request has been terminated > prematurely. > > Russ > > On Mon, Nov 29, 2010 at 1:42 AM, 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. > > > > Dan > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:339565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
