SQL Server 2005 + 4GB of RAM | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server 2005 + 4GB of RAM

Hi All, One server has 1GB of memory; the other has 2GB’s. I thought it would be good to get them both to at least 4GB. Besides having more memory available, what requirements/benefits are there to having 4GB’s instead of what’s currently installed? Are there any features we can’t evaluate? Are there reasons we would want to go beyond 4GB’s? Regards
Ashwin Reddy

More memory means always good for performance, as you’ve not mentioned the SQL Server edition and in Standard edition most of the features from like Enterprise Edition in SQL Server 2005, it also offers unlimited RAM! So, you can scale it as high as your physical hardware and OS will allow. There is a cap of 4 processors though. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.