Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clear cache?
Message
From
21/06/2000 12:49:47
 
 
To
20/06/2000 18:26:35
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00382225
Message ID:
00382777
Views:
20
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform