Create own dashboard to publish database pool usage metrics

Question

Question by Sharyl K. · Nov 22, 2013 at 05:58 PM ·

Create own dashboard to publish database pool usage metrics

We would like to build our own chart in dashboard to display - connection pool size, usage, max & min pool usage, acqu avg, acqu max and fail% (the information we see from dashbase dashlet - pool usage). Which method or sensor should we set up to get these data then create own dashboard? We want to create own dashboard and alerts.

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 · 2013-11-22T22:10:27Z

Answer by Rick B. · Nov 22, 2013 at 10:10 PM

Ah, OK. Please Edit your System Profile and go to the Measures dialog. Click Create and browse to Server Side Performance -> Agent Based Measures -> ADO.NET and select the appropriate measures with the appropriate database.

This should give you what you need for the pool usage stats, as for the acquistion times and failure rates per pool there is not a way to chart this as of now.

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.

Sharyl K. · Nov 23, 2013 at 06:32 AM 0

Share

We did that and it is not working. Based on support team, to get ADO.net measure, Oracle have to be added into PerfMon counter. In our case, they are NOT in PerfMon counter.

Answer 2 · 2013-11-22T20:44:31Z

Answer by Sharyl K. · Nov 22, 2013 at 08:44 PM

This is Windows server 2008, .NET agent

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

Answer 3 · 2013-11-22T19:53:12Z

Answer by Rick B. · Nov 22, 2013 at 07:53 PM

Hi Sharyl,

What Application Servers are you using? I know that WebSphere's PMI metrics publish this info, and we can pull it into dynaTrace via a "Custom PMI Measure"

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

Create own dashboard to publish database pool usage metrics

3 Replies

How to get started:

NAM 2019 SP3 is available

LIVE WEBINAR

Follow this Question

Forum Tags