May 21, 2011 at 12:44 pm
May 22, 2011 at 10:50 am
Good question to test our basics 🙂
M&M
May 22, 2011 at 11:29 pm
Nice question to start the Monday.
Thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 23, 2011 at 3:21 am
Good question. I answered it correctly by process of elimination.
May 23, 2011 at 3:33 am
Great question! Nice to start off the week with. Thank You.
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
May 23, 2011 at 4:58 am
Good question.
May 23, 2011 at 9:58 am
It's more correctly called the 'plan cache' these days. It used to be called the procedure cache, but since it doesn't just store the plans of procedures, the name has changed (though not all documentation is consistent yet)
http://msdn.microsoft.com/en-us/library/ms177441.aspx
http://msdn.microsoft.com/en-us/library/ee343986%28v=sql.100%29.aspx
http://msdn.microsoft.com/en-us/library/ms174283.aspx
http://msdn.microsoft.com/en-us/library/cc297252.aspx
http://msdn.microsoft.com/en-us/library/cc297250.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 23, 2011 at 9:59 am
Thanks again for another question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 23, 2011 at 2:34 pm
Thanks so much for a nice clear and easy Monday style question! 😉
May 23, 2011 at 2:45 pm
GilaMonster (5/23/2011)
It's more correctly called the 'plan cache' these days. It used to be called the procedure cache, but since it doesn't just store the plans of procedures, the name has changed (though not all documentation is consistent yet)http://msdn.microsoft.com/en-us/library/ms177441.aspx
http://msdn.microsoft.com/en-us/library/ee343986%28v=sql.100%29.aspx
http://msdn.microsoft.com/en-us/library/ms174283.aspx
After reading this post I went to MSDN online and pasted the following text from the question into search "memory pool that is used to store execution plans".
First result was msdn.microsoft.com/en-us/library/ms?181055 :
The part of the memory pool that is used to store execution plans is referred to as the procedure cache.
The second result was http://msdn.microsoft.com/en-us/library/ee343986.aspx :
Compiled plans are stored into a part of SQL Server's memory called plan cache. Plan cache is searched for possible plan reuse opportunities. If a plan reuse for a batch happens, its compilation costs are avoided. Note that in the SQL Server literature, the word "procedure cache" has been used to describe what is called "plan cache" in this paper. "Plan cache" is more accurate because the plan cache stores query plans of more than just the stored procedures.
So apparently not only does M$ agree with Gails statement, they have documented "Plan cache" and "prcodure cache" are the same and why "Plan Cache" is the perfered use in any new documentation.
May 23, 2011 at 4:01 pm
I liked this question. Thanks.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
May 23, 2011 at 5:06 pm
Nice question, thanks!
May 24, 2011 at 4:23 am
SanDroid (5/23/2011)
GilaMonster (5/23/2011)
It's more correctly called the 'plan cache' these days. It used to be called the procedure cache, but since it doesn't just store the plans of procedures, the name has changed (though not all documentation is consistent yet)http://msdn.microsoft.com/en-us/library/ms177441.aspx
http://msdn.microsoft.com/en-us/library/ee343986%28v=sql.100%29.aspx
http://msdn.microsoft.com/en-us/library/ms174283.aspx
After reading this post I went to MSDN online and pasted the following text from the question into search "memory pool that is used to store execution plans".
First result was msdn.microsoft.com/en-us/library/ms?181055 :
The part of the memory pool that is used to store execution plans is referred to as the procedure cache.
The second result was http://msdn.microsoft.com/en-us/library/ee343986.aspx :
Compiled plans are stored into a part of SQL Server's memory called plan cache. Plan cache is searched for possible plan reuse opportunities. If a plan reuse for a batch happens, its compilation costs are avoided. Note that in the SQL Server literature, the word "procedure cache" has been used to describe what is called "plan cache" in this paper. "Plan cache" is more accurate because the plan cache stores query plans of more than just the stored procedures.
So apparently not only does M$ agree with Gails statement, they have documented "Plan cache" and "prcodure cache" are the same and why "Plan Cache" is the perfered use in any new documentation.
I'm not at all knowledgeable in the subject, but from reading this it appears to me that they are quite different.
"Plan Cache" is used to cache the compiled plans in case of reuse opportunities.
Whereas "Procedure Cache" is used to store the execution plans, as per the original question.
Just taken from my simpleton viewpoint. 🙂
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply