• 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 Sathish S. · Jan 29, 2015 at 04:53 AM ·

Alert single database SQL takes more than certain threshold

We have a scenario that particular web transaction in the application caused table deadlock in which it takes down the database server. Application team wants to know what transaction that caused deadlock. The problem is purepath got timeout after 10 mins and we don’t whether we got that purepath or not.

So we are trying to monitor any SQL query which takes more than 5 mins and notify if hits that threshold. I’m not sure whether it can be done at the SQL query level to capture execution of single query instead of whole transaction? Any idea on this? if you anyone experienced similar problem, how do you handle this scenario ?

Ex: Purepath 1 has 1000 SQL queries and out of which 980 queries took less than 4 mins and 20 queries took greater 5 mins. We interested only 20 queries to monitor and capture it.

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. · Jan 31, 2015 at 12:49 AM

Hi

For Oracle Databases we have a great plugin that tells you the slowest SQL Statements independant of the PurePath: Oracle Monitor Plugin

For other databases - or - if you want to have a generic approach - you need to make sure that these SQL Statements are on the PurePath. Is it normal that your PurePaths take that long? If so - you can increate the timeout limit. You should however ONLY do this if this behavior is normal and PurePaths can really take that long. If you search for PurePath timeout limit you find the right settings to change this limit. If that is not normal i would first start with looking at these timed out purepaths and figure out how to make these TXs faster. If you e.g: have PPs with 1000 SQLs I wonder if this is necessary or not

Once you have that SQL Statement on the PurePath you can create a Business Transaction that filters those PPs where you have Dataase Exec Times > 10m. To create such a BT the easiest is to

a) open the DB Dashlet

b) right click on a SQL Statement

c) Select "Create Business Transaction"

d) In the upcoming Measure Dialog make sure you select the Database -> Time Measure type from the left tree

e) Remove the SQL Statement text itself so that this measure will capture all SQL Executions.

f) Give the measure a good name, set the upper severe threshold to 10000ms and then click on Filter

That should do the trick

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

2 People are following this question.

avatar image avatar image

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