Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Clear cache?
Message
De
21/06/2000 12:49:47
 
 
À
20/06/2000 18:26:35
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Divers
Thread ID:
00382225
Message ID:
00382777
Vues:
21
Ken,

I'm nowhere near the book and won't be until Monday. I'll be more than happy to find it then. Will that be too late?

I just reread your original post. It's not unusually for stored procedure to run very slower the first time their executed, especially after the SQL Server is restarted. Since query plans are not permanently cached, they're lost when SQL Server is restarted. So the first time they execute after a restart, SQL Server has to go through the entire process: resolution, optimization, compilation, and execute. Also, the data cache will be probably be empty as no queries have been executed to cause data pages to be placed in the cache.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform