RAM is a physical object within the server. There are two kinds of cache memory which reside within the physical RAM. These are the buffer cache and the procedure cache. This <a href="http://itknowledgeexchange.techtarget.com/sql-server/how-sql-decides-how-much-procedure-cache-and-how-much-buffer-cache-to-use/">blog post</a> explains a bit about the differences and how to figure out how much of each SQL will be using. The article references <a href="http://itknowledgeexchange.techtarget.com/sql-server/article-sql-server-memory-configurations-for-procedure-cache-and-buffer-cache/">here</a> goes into more detail.
Last Wiki Answer Submitted: October 27, 2009 3:34 am by Denny Cherry64,550 pts.
All Answer Wiki Contributors: Denny Cherry64,550 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.