What is the difference between RAM and Cache Memory in SQL Server 2005?
Home > IT Answers > Microsoft Windows > What is the difference between RAM and Cache ...
SQL Server Ask the Experts
2445 pts.
0
Q:
What is the difference between RAM and Cache Memory in SQL Server 2005?
RAM, Cache Memory, SQL Server 2005
What is the difference between RAM and Cache Memory?



Software/Hardware used:
sql server 2005
ASKED: Oct 26 2009  4:02 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 blog post explains a bit about the differences and how to figure out how much of each SQL will be using. The article references here goes into more detail.
Last Answered: Oct 27 2009  3:34 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0