SQL Server Performance Forum – Threads Archive
8GB RAM
Hi There, We recently upgraded our servers and the DB server now has 8GB ram. DB: 50gb in sizeOS: – WIN 2003 Enterprise
SQL – SQL 2000 Enterprise Edition This is a dedicated SQL server. But SQL is just using 1.9gb of ram. The settings are
1. Dynamically configure SQL server memory
2. Minimum memory 0mb
3. Maximum memory 8gb. Is there any other setting that needs changing.
Regards,
Ravi
Ravi, Have you configured AWE for the server. SQL enterprise will only recognize the additional memory if AWE is enabled. — to show advanced options – check AWE setting
SP_CONFIGURE ‘show advanced options’, 1
RECONFIGURE
GO
— to enable awe option
SP_CONFIGURE ‘awe enabled’, 1
RECONFIGURE
GO You also need to change a setting in the boot.ini on the server (PAE) http://www.sql-server-performance.com/awe_memory.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa_6b3k.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech — this one discusses the PAE option in boot.ini for win 2003
http://support.microsoft.com/kb/283037 Thanks
Mike
Check to make sure the settings are accurate for your environment. Make sure to have 8GB of RAM on servers, thus the min/max memory settings should be adjusted and the Boot.ini might not require the /3GB. If you’re getting performance issues with the queries then refer to this KBAhttp://support.microsoft.com/?id=243588 for information. I suggest you to want some good monitoring with performance history collection. Learn what ‘normal’ is for your system and set alerts to catch conditions outside of normal. Monitor resource consumption (disk space, CPU, memory stress, etc.) to learn when you are outgrowing your existing system. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>