question

Josep C. avatar image
Josep C. asked ·

Monitor the time to get a database pool connection

Hi all,

in some disaster recovery tests we are interested in monitor the time taken to balance from one database instance to another. To do this we want to monitor the time taken to get a database connection form the pool.

Dynatrace AppMon shows the Acqu Time in the pure paths and database dashlets but there's no measure available to chart this. So, one way to achieve the information was putting one sensor in the getConnection method and define one Time measure on it to char the information.

The system gets the connection with WrapperDataSource.getConnection so if we put one sensor in this method we don't see any those calls in the pure paths:

But if we disable the JDBC sensor:

we see all the JDBC calls in the pure paths and database dashlets (but not the aggregations, etc..)

So, my question here was why?

Thanks in advance, Josep Maria

configurationdashboarddatabase7.2measures
1.jpg (256.4 KiB)
2.jpg (512.0 KiB)
3.jpg (134.0 KiB)
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.

0 Answers