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.
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"
This is Windows server 2008, .NET agent
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.
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.
