question

Thomas E. avatar image
Thomas E. asked ·

Alerting on Apache DBCP pool usage

I know (from this article Monitoring Apache DBCP connection pool) that since the old apache DBCP has no JMX metrics exposed I can not collect and report on usage of the pool. I am sure this is a silly question but since somehow on the Database dashlet in v5.0, I do see a value for the pool usage metrics(see image below), I was wondering how it was gatehring this and if there was anything exposed I could set a Incident up to alert on? I have started the conversation with our Dev side on maybe moving to something newer like Tomcat CP or C3PO, but that will take time.

Any tricks anyone has?

 

10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Thomas E. avatar image
Thomas E. answered ·

 

Thanks, makes total sense. I was only looking to Pool usage as a early warning to a hot spot. I'll take the approach of looking into setting up some BT's on connection requests and look to alert off that once I can establish a pattern.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Ryan C. avatar image
Ryan C. answered ·

I believe the pool usage data is calculated through PurePath data (the SQL activity in the transactions), not JMX. Here's an interesting article that might shed some light.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Don B. avatar image
Don B. answered ·

I would also be interested in this info as we have an application using DBCP as well. We are on dynatrace 5.5 and I do not see a way to create a measure for this info in that version either.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.