• 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 zuher r. · Dec 09, 2014 at 06:08 PM ·

Getting Top 10 expensive SQL Queries with fetching time included

Hi all

I need to create top 10 worst performing SQL queries , the problem i am facing with this is including  the fetching time (my worst SQL exection time excutes within ms but it took more that 45s in fetching ) .

is there any work around to include the fetching time by using the API total time (like ADO.NET API time) to statement execution  time?

any thought that help is appreciated.

 

 

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.

5 Replies

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

Answer by zuher r. · Dec 18, 2014 at 05:21 AM

Thanks Andi for the reply.

as you mentioned , it is not practical to do this as more than 70% of the calls to DB is having this fetching time and it is not possible to do it for all of them using custom censor unless of course we are lucky and the customer uses standard library for db access.

we already asked for any specific time or plan that include specific time when we will see this feature in Dynatrace,can you please check and give us some hunch about it .

one more thing , is this feature considered  RFE or you think it is a must in the product ??

 

thanks.

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.

avatar image

Answer by Andreas G. · Dec 13, 2014 at 08:52 AM

Hi

Sorry for the late reply. In the moment we dont include the fetch or cursor time in SQL Executions. There are plans for this in future releases but right now we do not capture this as part of the ADO.NET Calls which show up in the Database Dashlet. We will capture some of this time through our Auto Sensors in case fetching is a performance problem.

One option you have is to place your own custom sensors on these fetch methods. This will show the time spent in these methods -> so - you will see it in the PurePath and also the Methods Dashlet -> not in the DB Dashlet though. But one thing to remember: if you have a lot of fetch calls then your PurePaths may grow significantly in size

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.

avatar image

Answer by zuher r. · Dec 13, 2014 at 03:19 AM

Hi 

any one has any news regarding this request???

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.

avatar image

Answer by zuher r. · Dec 10, 2014 at 12:39 AM

Hi Wei,

if you are executing a query inside MS ADO.NET  , ADO will start streaming you the first bits of the result .

we have seen that the sql statement execution time taking very small amount of time, but we still see that ADO.NET API is taking most of the transaction time due to the fact it add up the time till the last bit of the records streamed back to the application (fetching time of the result).

please look at this post to get the idea.

Database Time contribution tier

 

thanks

 

 

 

 

 

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.

avatar image

Answer by Wei D. · Dec 09, 2014 at 09:27 PM

Hi Zuher,

What do you mean by "fetching time", is it the time spent on fetch the database connection from the connection pool?

Wei

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