Does the duration contains the time from DB completed query and the client successfully received the data?
Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.
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.
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?
Query duration is aggregation of time for compiling and executing the query. More details here.
Please let us know if you need further information regarding this,
@MatthewShi-3240 Please let us know if you need further help regarding this.
2 people are following this question.
Which are the most common performance challenges with Microsoft Azure SQL?
How to Generate Primary Key and store in AAD Token for Future Sessions?
Azure SQL Managed Instance - Error while connecting to Analysis Service - "The OLE DB provider "MSOLAP" has not been registered"
Can you recommend the best/simplest way to regularly audit the IP Address Whitelists of the following Azure Resources: API Gateway, Storage Account, Function App, SQL Server/DBs