> > the SQL server is being made. It doesn't matter if I turn the setting > on or > > off, the behaviour is the same which is a real bind as it's pushing > the SQL > > server right up to its memory limit within 24 hours of a service > restart. > > If opening and closing a connection causes a memory leak, your SQL > server has > bigger problems...
Thanks for that. To be clear. The CF is opening a connection for every query that is being run. It looks distinctly like a JDBC issue but I have no idea why it should be ignoring the connection pooling settings. The event viewer is filling up with thousands of success audits and connection notifications for the CF db user accounts. The rate is at least 1 successful DB connection every second... Also, the server is a production server that had an in situ upgrade from CF6 for CF8. It didn't do this until CF6 was installed... Paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
