March 30, 2006 at 11:31 am
SQL 2000 Enterprise Edition on a Clustered Windows 2000 Advanced Server is only using 1.7G of RAM. Shouldn't this be able to use more of the 4G it has.
SQL is configured to use 3.5G.
Any thoughts?
Thanks
Dan
March 30, 2006 at 12:10 pm
In the boot.ini is the /3GB switch set.
April 3, 2006 at 11:48 am
Without using the /3GB switch in the boot.ini file (and other 'default' parameters), no matter what you set you min/max server memory for SQL Server to you will only see 1.6-1.8 Gb or RAM being used in the Task Manager.
Using /3GB in the boot.ini combined with the following sp_configure options:
exec sp_configure 'awe enabled', 1
exec sp_configure 'min server memory (MB)', 3072
exec sp_configure 'max server memory (MB)', 3072
and possibly:
exec sp_configure 'set working set size', 1
Then after a Windows restart on each side of the cluster you will see in Task Manager that you are probably using about 2.6-2.8 Gb of RAM. In reality you are using 3 Gb (the maximum in withouy the /PAE switch in the boot.ini file), but some memory structures do not show up.
Using /PAE switch in the boot.ini file just to get to 3.5 Gb of RAM usage would not be recommended. When using /PAE option, Windows needs 1 Gb of RAM just to manage the additional memory you request. I believe that most standard practices suggest not using it unless you really need (and have) quite a bti of RAM (16+ Gb) on you SQL Server.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply