Jason, You stated that connections should be set at 5 * CPU cores, is that the cores on the CF server or the SQL server?
Also... What happens if you have multiple data sources. Do you use the same settings for each data source, or do you split that 5 * CPU cores across the data sources? Steve -----Original Message----- From: Jason Fisher [mailto:[email protected]] Sent: Friday, May 14, 2010 7:37 PM To: cf-talk Subject: Re: ColdFusion memory leaks 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 :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:333750 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
