DB Time and/or count splitted or filtered by connection pool

Question

Question by Josep R. · Feb 16, 2015 at 03:22 PM · business transaction

DB Time and/or count splitted or filtered by connection pool

I want to create one chart with DB Time but filtered or splitted by connection pool. My customer has 2 connections pools and he wants to see the DB Time but only for one of these connection pools.

How can I do this?

Thanks in advance!

0

10 |2000000 characters needed characters left characters exceeded

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

Answer 1 · 2015-02-16T22:45:49Z

Answer by Andreas G. · Feb 16, 2015 at 10:45 PM

Hi

There is no out-of-the-box feature for Measures per Connection Pool. But - depending on your AppServer you can create your own custom JMX Measures to pull in the data for your individual Connection Pools. Open your System Profile -> Measures -> pick one of the Custom JMX Measures under tha Agent-based Measures and then browse through the available JMX Measures with the Metrics Browser. Search for "connection" or "jdbc" - you will most likely find the right JMX Measures

Once you have these measures defined dynatrace will capture them and you can chart them

Andi

0 Show 1 · Share

10 |2000000 characters needed characters left characters exceeded

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

Josep R. · Feb 17, 2015 at 04:19 PM 0

Share

Thanks Andi,

my AppServer is WebSphere, so with these JMX measures is possible to create one Dashboarts with DB Count/DB Time splitted by connection pool? How can I create a BT filtered or splitted by these JMX measures? My customer is interested in seeing these measures, DB Time/DB Count, but separated...

Thanks!

DB Time and/or count splitted or filtered by connection pool

1 Reply

How to get started:

NAM 2019 SP3 is available

LIVE WEBINAR

Follow this Question

Related Questions

Forum Tags