question

MatthewShi-3240 avatar image
0 Votes"
MatthewShi-3240 asked NavtejSaini-MSFT commented

How does the duration exactly mean in Query Performance Insight

Does the duration contains the time from DB completed query and the client successfully received the data?

83630-image.png


azure-sql-database
image.png (104.5 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MatthewShi-3240

These are the statistics for a particular query over time giving the execution count and the duration it ran for. Here is a document explaining that in detail.

Please go through the same and get back to us for any questions.

Regards
Navtej S


0 Votes 0 ·

Thanks, Navtej, but I want to confirm that does the duration contains the time from db to client? After the DB complete the query, it need to return the query result to client, so if the client has the network issue, this process must be slow, so does this time included in the duration?

0 Votes 0 ·

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered NavtejSaini-MSFT commented

@MatthewShi-3240

Query duration is aggregation of time for compiling and executing the query. More details here.

84663-image.png

Please let us know if you need further information regarding this,

Regards
Navtej S



image.png (33.3 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@MatthewShi-3240 Please let us know if you need further help regarding this.

0 Votes 0 ·