Voltar
-
TÃtulo
Clarification on Execution Statistics -
Descrição
A meaningful description of :
- Execution Elapsed Time
- Total Elapsed Time
- Response Time
- Execution CPU Time
- Compile Elapsed Time
- Compile CPU Time
.jpeg)
-
Resolução
Execution Elapsed Time, Execution CPU Time, Compile Elapsed Time, Compile CPU Time
- These four statistics are obtained by setting STATISTICS TIME ON when execution the SQL statement.
Please refer to this link for further information:
https://docs.microsoft.com/en-us/sql/t-sql/statements/set-statistics-time-transact-sql?view=sql-server-ver15
Total Elapsed Time
- This figure is calculated by adding "Execution Elapsed Time" and "Compile Elapsed Time", which shows the total time spent in the server to process the SQL statement.
Response Time
- This is obtained through the Provider Statistics for SQL Server in ADO.Net. The statistics related to this figure is the NetworkServerTime which "Returns the cumulative amount of time (in milliseconds) that the provider spent waiting for replies from the server once the application has started using the provider and has enabled statistics." Please see this link for further information:
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/provider-statistics-for-sql-server