• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Alfred R. · Apr 18, 2014 at 06:10 AM · production

Alert on DB pool usage percentage utilization

A customer has a Websphere hosting an application (2 JVMs on two different servers) that connects to around 10 different databases, they recently are facing problems with database not accepting connections due to connection pool filling up.

The problem is other applications (JVMs) that does not have a dynaTrace agent also connects to the database. Also the "Pool Usage" dashlet that appears in the Database Dashboard shows the "Average DB pool usage" during the chosen period but not the "current", the closest number that I could see or think is "the current" pool usage is "Last Pool Usage" - I am not sure -

Now if "Last Pool Usage" is actually the real "current pool usage":

1- I could not find "Last Pool Usage" as a measure to put upper limit to create an incident and alert on.
2- Does the value of "Last Pool Usage" include the usage of other JVMs that doesn't have dynaTrace agent?
3- Will the incident occur if any of the 10 databases exceed the limit or of the average of all DBs pool usage exceeds the limit? 

If the "Last Pool Usage" is not a measure I can use or not the actual "current pool usage" or it doesn't count the other connections from other (JVMs), what other possibilities do I have? Are there any other measures that would do the job? Does the "Oracle Monitor Plugin" a solution?

Any help is appreciated...

Thanks,

Alfred

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Reply

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Andreas G. · May 05, 2014 at 02:11 PM

Hi Alfred

Our Agent only gets the Connection Pool Statistics from the Application that you have instrumented. That means these values do not reflect connection pool information from your other JVMs that you have not instrumented.

We capture the "pool usage" statistics on the PurePath when the app gets the connection out of the pool - that is the getConnection method that we instrument. When opening the database dashlet the pool information you see is an aggregate of all PurePaths from your selected timeframe, e.g: Min, Max, Avg of Last 30 Minutes. If you want to get the "Last or Current" value you need to look at a PurePath of that timeframe and open the details on the getConnection method.

To "monitor" Database Connection Usage its best practice to capture additional JMX Metrics that your App Server exposes. If you go to your System Profile under Measures you can create Measures for WebSphere. There is a list of pre-configured JDBC JMX Measures. You will find them under Server-Side Performance -> Agent based Measures -> WebSphere. Once you have these measures created it will be easy to put them on a chart and monitor them. You can then also set up Alerts and Incidents.

But Remember: these are the connecction pool statistics FOR YOUR APPLICATION - NOT for the overall database or other Apps

Andi

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

No one has followed this question yet.

Related Questions

Howto modify content-type header of URL Monitoring Plugin

Measurement consumption increase after Synthetic Test Integration for Dynatrace Application Monitoring: change 5 minutes interval?

Performance overhead of enabling bind value capturing and increase the SQL capture length

Extended Email Plugin stopped sending email suddenly

Unix System Monitoring Issue

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A