July 23, 2009 at 10:49 am
I am just trying to analyse where memory(physical or virtual ) is used for sql queries.
my understanding is sql server uses memory to save data and query plans so that next when the same data or query ma be resued for faster retrival of results and when every time sql server service is restarted it celans up and so it make take some longer time to retrive the same result as there is no query plan saved.
Let me know if my understanding is wrong and if anythign else i need to know.
thanks
July 24, 2009 at 6:07 am
That more or less describes it, yes. You also know that execution plans can age out of cache and then need to be compiled again, right? Or that certain actions or situations can cause queries already in cache to need to be recompiled? Also, data stored in cache can get pushed out by other data since it's pretty much a FIFO system (first in, first out).
There are a gazillion details after that (most of which I'm still learning), but you've got the basics clear.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply