cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

System.Data.SqlClient.SqlException

prasad_lele
Newcomer

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

 

How can I see this

 

3 REPLIES 3

Babar_Qayyum
DynaMight Guru
DynaMight Guru

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
Participant

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
Advisor

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

 

 

 

Featured Posts