How to interpret the duration of the purepath when it refers to multiple executions of the same SQL query? Is this the duration of all requests or the duration of a single request? In this case the purepath is the consequence of a consolidation because the queries were executed one after the other or because the pattern of the query was identified several times during the execution of the purepath?
The duration of the PurePath from start to end.
It is the wall-clock time (difference between start and end time), not the sum of all asynchronous executions.
Have a look at the below link for more insight.
@Babar_Qayyum wrote: DG Customer First
You are right. I did not notice the shared link by you. This is the response time of all SQL executions. At the code level, the duration can also explain client-side response time for these executions.
Thank you. I will try your methods to increase my knowledge.