SQLCONNECTIONPOOL growing very huge
One of my db server SQLCONNECTIONPOOL growing very huge,it consumed 55GB , out of 65Gb (sql MAX) memory) Environment: Microsoft SQL Server 2017 (RTM-CU25) Standard Edition
How can i reduce the SQLCONNECTIONPOOL size ?
In my experience it was a driver problem.
Basically, some application is calling sp_prepare system procedure through an JDBC driver and do not call sp_unprepare. This seems to be a bug in the JDBC driver. There’s not much to do on the MSSQL server.
So try to see if you are using the last version of jdbc driver.