The fact that FR wouldn't crash it tends to make me think that ColdFusion is waiting for a response from the SQL Server. As I understand it, once its waiting on the database server its out of ColdFusion's hands in JAVA is waiting for the response.
You should look at both your ColdFusion and SQL code. Just because the code hasn't changed doesn't mean there wasn't a problem in the first place that just never got found. I had a piece of code that worked for years, the users would pick a date range and it would summarize the data and put it in a report. For two years users did date ranges anywhere from a single date to a month, then one user decided that he needed the data summarized for an entire quarter. The system crashed under the load because of some bad SQL that hadn't been caught and yes we did see similar problems with the ColdFusion server but it was because it was waiting for the SQL server. Steve -----Original Message----- From: Richard Steele [mailto:r...@photoeye.com] Sent: Tuesday, October 02, 2012 7:04 PM To: cf-talk Subject: Re: CF8 Instance hogs cpu We had set this up before, but did not have good results. More often than not, it wouldn't crash the request, and would just keep it in limbo. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:352838 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm