What is the difference between RAM and Cache Memory in SQL Server 2005?
What is the difference between RAM and Cache Memory?



Software/Hardware used:
sql server 2005
ASKED: October 26, 2009  4:02 PM
UPDATED: October 27, 2009  3:34 AM

Answer Wiki:
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 Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _