Hi. To give context to others, from what you saw, the code in the Java database class was properly opening and closing connections, however the cfscript code that used that class may have been incorrectly coded in so far as it was not apparant if the calls to the database (to execute SQL) were properly opening and closing just one connection at a time. @BKBK if you want to explain that better, please do 🙂 I have now made modifications to a lot of templates that had database calls, and am testing to see if the system behaves any better. Just to reiterate, we are using this MSSQL query to check how many connections to the server are occuring. This is the query which previously has yielded more and more results - it never frees up any rows: SELECT * FROM master.dbo.sysprocesses(NOLOCK) WHERE (spid > 50) AND (status = 'sleeping') AND (program_name LIKE '%jdbc%') I am not sure if this query should yield a larger and larger result set, or if it should get smaller (automatic data purge by MSSQL) at some point? If someone knows that, I'd appreciate your input. I will update again soon after watching the server. I do hope, as @BKBK says, that the code may be the problem, but so far this remains unknown Regards, Mark
... View more