How to find concurrent database connection in thread dumps?

[david kreuter]

In order to analyse if the currently used database setup is sufficient for the running Confluence instance I need to see how much concurrent connections are used by the instance.

In the documentation is stated: "To assess whether you need to tune your database connection pool, take thread dumps during different times (including peak usage). Inspect how many threads have concurrent database connections." - https://confluence.atlassian.com/x/8fwB

Whats the best way to find the number of concurrent connections in the thread dump? What are the keywords (class names) to search for?

[Alex Perez · Accepted solution]

Hi David,

Depending on you database connection method (datasource or direct JDBC), and your database, I'll suggest you to search for the driverclass of your database river.

In my scenario, using oracle I may search for "oracle.jdbc.driver".

Another option is the admin console of your application server: tomcat, jboss, weblogic ... Most of them have a option to see the current size of the datasources: min, max, current-in-use... etc.

HTH