SQL server performance with move than 1 Gb RAM | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL server performance with move than 1 Gb RAM

We have around 20 customers running SQL server 2000 Enterprise Edition and each of these servers have 2GB or more RAM. When I configure SQL server to dynamically use upto 1.5 GB, I see that SQL server gives a very poor response time when it gets close to 1.5 GB. Sometimes, the clients complain that they get error messages becuase the server is not responding. I have to fix the memory to 850 Mb to make SQL server work smoothly. Has anyone seen this issue before? We have a lot of RAM at our customer sites that are not being used at present. I wish we were able to use this more effectively for data cache. Thanks.
You sure it’s Enterprise Edition and not Standard Edition? What flags do you have on in the boot.ini file of the server? I would assume you do not have awe enabled turned on? What service pack level are you on for SQL Server? What is the OS? What is the service pack for the OS? You need to leave minimum 1GB free for the OS, regardless of your configuration. Otherwise, you will have problems. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
check SQL error log. Any error on memory ? standard edition can use up to 1.58 GB only, any value beyond that, SQL will raise error.
Hi simpsonl,
please read / refer following article :
http://support.microsoft.com/default.aspx?scid=kb;en-us;168697
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_config_9zfy.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_1fnd.asp http://www.sql-server-performance.com/hardware_tuning.asp#Memory
http://www.sql-server-performance.com/sql_server_configuration_settings.asp
http://www.sql-server-performance.com/awe_memory.asp
Regards. hsGoswami
[email protected]m
]]>