topic System.Data.SqlClient.SqlException in Open Q&A

System.Data.SqlClient.SqlException

prasad_lele — Wed, 31 Aug 2022 10:52:20 GMT

I am getting this error and I want to see what was the connection pool usage at this time.

How can I see this

Re: System.Data.SqlClient.SqlException

Babar_Qayyum — Thu, 12 Sep 2019 13:42:50 GMT

First of all, connection pools information is available for the following technologies if you are talking about AppMon.

If you have anyone supported technology, then open the Database Dashlet to know about the pool usage or create a service-side performance chart for the connection pool size, percent used, etc.

Regards,

Babar

Re: System.Data.SqlClient.SqlException

Sanket_Molavade — Thu, 21 Jul 2022 08:56:37 GMT

Hi @Babar_Qayyum

Can you please guide me on how we show database connection pool usage.

I am getting errors like JDBCConnectionException: Unable to acquire JDBC Connection and HikariPool-***** - Connection is not available, request timed out after ***** and I have database connection pool size 5000, so I want to check actually how many connection pool is used for how much load.

Thanks & Regards,

Sanket_Molavade.

Re: System.Data.SqlClient.SqlException

richard_guerra — Fri, 22 Jul 2022 21:30:19 GMT

Hello @Sanket_Molavade ,

In Settings -> Monitoring -> Monitored technologies, you'll find JBoss Connection Pools, Tomcat Connection Pools, WebLogic Connection Pools, and WebSphere Liberty Connection Pools that can be enabled. I believe these metrics are not enabled by default as they consume DDU licenses.

Once enabled, you'll find the metric in Data Explorer, e.g. builtin:tech.tomcat.connectionPool.numActive

You mention Hikari - I don't believe that will be included under Tomcat. There is facility to add jmx extensions: Monitoring -> Monitored technologies -> Add new technology monitoring -> Add JMX/PMI extension. You'll have to know the schema - and I don't have personal experience to advise if Hikari exposes it's connection pool metrics there...