Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
More on performance
Message
 
 
À
21/12/2010 14:46:11
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01493511
Message ID:
01493514
Vues:
75
>I do not understand this situation. All fields used in the query are indexed. I also have some combo index to satisfy the execution plan. The result returns one record. However, based on the conditions, it can take between one and 40 seconds. What else could be a factor?

There could be zillion of factors. The current work load on the server, which plan the optimizer chose for the query, how many I/O operations (page reads) were involved in the query, etc.

Although the difference in numbers is too drastic.

Take a look at this blog post Glenn Berry Query Optimization Diagnostic Queries
and try running them to analyze the situation.

Also, are you using ad-hoc query or stored procedure with the compiled plan?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform