Tchater maintenant avec le support

Obtenir une aide instantanée
Terminer l’enregistrement

Se connecter

Demander les tarifs

Contacter le service des ventes

VERSIONS D'ESSAI GRATUITES

Clarification on Execution Statistics (4366230)

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

Clarification on Execution Statistics
Description

A meaningful description of :
- Execution Elapsed Time
- Total Elapsed Time
- Response Time
- Execution CPU Time
- Compile Elapsed Time
- Compile CPU Time
Résolution

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

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Demander un article de la base de connaissances

Leave a Comment

Contenu recommandé

Produit(s) :: SQL Optimizer for SQL Server
11.0, 10.1.2

Sujet(s) :: Troubleshooting

Historique de l’article :: Créé le : 12/22/2020
Dernière mise à jour le : 6/17/2024

Rechercher tous les articles