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.