SQL Server Performance Forum – Threads Archive
SQL Server 2005 + 4GB of RAMHi 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
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.