System.Data.SqlClient.SqlException

[prasad_lele]

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

How can I see this

[Babar_Qayyum · Accepted solution]

Hello @Prasad L.

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

[Sanket_Molavade]

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. 

[richard_guerra]

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...