Hi Thomas, It's a real relief (in a way) to know we are not the only ones experiencing this issue - as at least if it is a recognised issue, macrodobe may fix it at some point (although based on my experiences today even attempting to send a support email to adobe, I wonder if that is a valid assumption)
First time in over six years of using CF that I've had a crash that I haven't been able to ascertain the cause... been tearing my hair out... Thanks for your suggestions with regards to SQL connections - I will look into these and see if any are relevant in our hosting environment. Have other people just been having a problem with CF 7? or has it also been an issue in CF 6.1? Also, has anyone experiencing this problem found any benefit from installing the 7.0.2 updater? - I have scheduled downtime for midngiht tonight to install the updater... not that I could see anything in the release notes that made me hopeful that this would make any difference... Cheers Dan. On 9/18/06, Thomas Peer <[EMAIL PROTECTED]> wrote: > > Hi Daniel, > > Pretty much everyone running CF/Windows/SQL Server has this problem. > > See my page here > > http://www.digitalmethod.co.uk/cf/ > > There is no guaranteed fix other than to have an alert system in place to > monitor memory usage and restart when it gets over 90% or so. > > Don't waste time playing with garbage collection - you also might do more > harm than good. The only settings you might want to consider playing with > are the SQL connections settings - the method (cursor or direct), the max > number of connections and maintain connections. > > I've seen people mediate the problem reasonably well by splitting DSN's > into two - one cursor connection that doesn't maintain connections and one > direct with maintained connections for smaller queries. > > When the system goes into the state you describe it's often quicker to > restart the server than wait for CF to restart (sometimes it never does). > > Tom Peer > Digital Method > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253459 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4