Sounds like a SQL problem more than a coldfusion problem.. look at some of the sql server tools that can be used to find problems like this, <http://www.microsoft.com/downloads/en/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en>http://www.microsoft.com/downloads/en/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en
At 03:18 PM 11/28/2010, you wrote: >88 minutes ago, 5 different requests to various pages on the >classcreator web site died while executing SQL Statements. There is >nothing unusual about the SQL Statements, and in each case, these >statements are executed tens or hundreds of times per minute with no >problem. > >Since that time, 88 minutes ago, no additional queries have frozen any >requests, but those 5 requests are still hanging (Fusion Reactor >reports attempting to kill them, but the SQL calls are native threads >so it cannot kill them). > >Since the instances were restarted approximately 107 minutes ago, the >server has processed about 60,0000 requests, and only these 5 hung, >all 5 at the same time. > >Anybody have any ideas what might cause something like these? We've >had it happen several times recently.... we're running CF8 enterprise >on Win2k8 ... (upgrading to CF9 next weekend!) > >I hate that the only way to kill these threads is to restart the CF >instances... > >Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:339560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
