cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

I able to see database queries avergae execution time in Dynatrace

Hi Team,

If any one of the query executed more than one time, I able to see average time in Dynatrace.

For example,

Same query executing many times and I able to see average time only(consolidated ). I want to see execution time for each and every query if same query also(i.e if same query executed 100 times mean, I want 100 rows in Dynatrace instead of one rows)

See the screen shot.

4 REPLIES 4

florent_duchate
Dynatrace Pro
Dynatrace Pro

Hi

You cannot do this directly from this view as it only shows aggregated data.

I can think of 2 ways to achieve this but not exactly as you are describing it.

- Right click on the query, select dril down, purepaths.

This will open a new screen showing all the purepaths containing the individual queries. You will have to check each purepath to see the individual execution times.

- Alternatively, create a measure for a specific SQL statement and make sure that you are collecting percentiles data. You can then chart the values to see how the response time is distributed.

Regards

mmannava
Newcomer

What is measure name we can use for Mysql DB in which to get the RT/sec information ?

mmannava
Newcomer

I am searching for dynatrace measure for this requirement.

Hello Mohana,

You can use the Execution Count (Represents the number of executed statements regardless of whether the statement has been prepared before or not).

or

PurePath Node Count: Number of (visible) nodes of the PurePath.

Regards,

Babar