If any one of the query executed more than one time, I able to see average time in Dynatrace.
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.
Solved! Go to Solution.
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.
You can use the Execution Count (Represents the number of executed statements regardless of whether the statement has been prepared before or not).
PurePath Node Count: Number of (visible) nodes of the PurePath.