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 enter image description here

    enter image description here 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.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2