In addition to the other good suggestions so far, check your datasource settings. It is often the case that datasources are allowed to have a huge number (or even infinite) connections to the database, and there are often excessive timeout values with each datasource as well. If CF sits patiently waiting for DB calls that don't ever return, you run out of threads (and memory) pretty quickly. Limit number of connections to something like 5 x CPU cores, and set Timeouts to 15 min and 5 min. If you're running SQL Server, I also recommend 20 seconds on the Login timeout, since that's the default on the DB side already.
Last but not least, if you're on SQL Server, please allow it to Maintain Connections ... the RDBMS is better at managing its threads than the JVM :) On 5/14/2010 5:24 PM, Qing Xia wrote: > Hi, > > I am new to ColdFusion server monitoring, so I am trying to get some ideas > here to get me move in the right direction. > > We have a situation where our production ColdFusion applications are using > more and more memory until they bring the server to a halt. I was informed > (I am new here) that our systems administrator actually wrote a batch script > to automatically restart the ColdFusion server every Sunday morning to avoid > this very problem. Despite this, the memory leaks still make it necessary to > manually restart the ColdFusion server from time to time (could be every > couple of weeks). > > CF8 comes with pretty decent server monitoring tools including memory > monitoring but I dare not run it in production since it is such a memory > monster. Without purchasing other monitoring software like SeeFusion or > BlueDragon, what are my options here? I see that there is an option in > CFAdmin to periodically recycle JVM memory once it reaches a threshold, but > I am a little too concerned to use it--it is not really like fixing the > problem. > > Any idea will be most appreciated! > > Thanks, > > Qing Xia > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
