• 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 Steve D. · Dec 13, 2014 at 02:45 AM ·

Filter JDBC calls by query text (DT 6.0)

Hi,

we have a web application which uses a lot of JDBC calls, some of which are known to have long execution times. I want to focus on queries beginning with a specific string e.g. 'select a, b, c, from xyz'. Is is possible to filter the database or database hotspots views to queries matching a particular regex?

Also, is it be possible to graph this subset of queries (max exec time etc.) without creating a measure?

Thanks
Steve

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.

2 Replies

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

Answer by Steve D. · Dec 15, 2014 at 10:49 PM

Hi Tom,

Thanks for the reply. When I'm setting up the business transaction does that not need to create a new measure?

The reason I ask is that I want to look at these response times for a production environment where I'm not able to make changes to the DynaTrace configuration (system profile) but can report on existing data.

Thanks
Steve

Comment

People who like this

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

avatar image Thomas L. · Dec 16, 2014 at 02:27 AM 0
Share

Yes, creating a new Business Transaction will generally require you to create new measures. If you're unable to get a new measure created, your options are severely limited.

avatar image Steve D. Thomas L. · Dec 16, 2014 at 08:58 PM 0
Share

Thanks Tom, not what I was hoping but cheers for the help!

avatar image

Answer by Thomas L. · Dec 13, 2014 at 03:53 AM

Hi Steve,

I'm fairly certain what you want isn't possible without creating a Business Transaction first. The Business Transaction would be able to filter out the DB queries you're interested in and also allow you to chart them. This would obviously only apply to transactions that get analyzed once the BT is created. However, it is possible to export a session, create a BT, and then reanalyze the session so the BT gets applied to the session. Depending on the size of the session, this could be a solution. I would still suggest you create a BT for all future transactions.

For more information on Business Transactions: https://community.compuwareapm.com/community/display/DOCDT60/Usage+of+Business+Transactions

I also wanted to point out that you are able to do a search within the DB dashlet. You can do a Ctrl + F and go from there. This method would not work with charting though.

Tom

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