SQL Server Performance Forum – Threads Archive
Relation between RAM size,data cahe and table sizeHi,
I read an article about data cache ih this site. http://www.sql-server-performance.com/tp_analyzing_sql_server_2000_data_caching.asp In that article it has been mentioned like data cache increases with RAM size.But there was no exact figure.I would like to know if we increase the ram size from 2GB to 4GB then what will be the size of data cahe? Regards,
There is no definitive answer, SQL Server itself manages the data cache. Remember that article was written for v. 2000 and not 2005. The more RAM you have, the more SQL Server will use for data cache. But it will also use RAM for other things, lock management, procedure cache, connections, extended stored procedures, CLR etc etc. So there are many variables. For your particular case, the only way to find out is to test and evaluate.
Thanks Thomas…<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’‘ /><br /><br />Regards,<br />SARAVANAN.G<br />
Do you have any performance issues with Data caching at present? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
http://searchsqlserver.techtarget.com/searchSQLServer/downloads/Guru_Guide_to_SQL_Server_Architecture_Chap%2011_AWL.pdf Read the above chapter from Ken Henderson book for more info…