We've been having stability issues ourselves, and can't figure out why. It relates to sending email, a task that does a lot of sql as well as string processing activity. The memory doesn't seem to jump that much, but the server restarts every so often. We haven't been able to pinpoint the cause yet, but this seems like a good culprit. We are on SQL 2k and cf 7.0.1
Are there any updated drivers available? Russ > -----Original Message----- > From: Ken Ferguson [mailto:[EMAIL PROTECTED] > Sent: Monday, September 18, 2006 5:06 PM > To: CF-Talk > Subject: RE: Excessive Memory Usage CFMX 7 Standard Windows 2003 resulting > in Crash > > Come to think of it, virtually all of my CF performance problems started > just about the time I added an application to the server which uses SQL > Server. This is a server on which there are only about two or three > people at any given time - MAX. I wonder if this is a driver issue or > what? I just looked right now, because pages are taking forever to load > and the jrun.exe is using 312,469K of memory and 97% of CPU. I've got > another server with Win2K and SQL Server which has MUCH more traffic and > jrun.exe is using 55,144K and hasn't restarted in weeks. > > Thanks, > > Ken Ferguson > 214.636.6126 > > > > > -----Original Message----- > From: Daniel Lancelot [mailto:[EMAIL PROTECTED] > Sent: Monday, September 18, 2006 3:48 PM > To: CF-Talk > Subject: Re: Excessive Memory Usage CFMX 7 Standard Windows 2003 > resulting in Crash > > 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:253463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
