SQL Server Memory Config

[chatridge]

I have the following running as my MS SQL Server:

Microsoft Windows 2003 Enterprise
Microsoft SQL Server 2000 Enterprise
6.5GB memory

I am trying to configure my server so that SQL uses 5.5GB of memory, leaving 1GB for the OS. I have added the following switches to my boot.ini file so windows can take advantage of the additional memory:
/PAE /3GB
I also issued the following statements within query analyzer:

sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 5632
RECONFIGURE
GO

sp_configure 'mix server memory', 5632
RECONFIGURE
GO

The properties of my server within Enterprise Manager show that my server does have 5632MB configured for its fixed memory. SP_Configure also shows the correct values for both min and max configured memory.

The question I have is that when I go into task manager - processes and view the amount of memory that sqlservr.exe is using, it only displays 2,897,084KB of memory and not 5,767,168KB. Any idea why sql isn't using above 2.76GB of memory when I configured it to use the full 5.5GB? Do I need to include the /awe switch in my boot.ini? Is task manager displaying an incorrect amount? Are there any other methods I can use to confirm the amount of memory SQL is consuming. I do not want memory allocation for SQL to be dynamic.

Thanks for any help anyone can offer!

 

[SQLDenis]

Maybe I doesn't need all that memory...yet
Try running some crazy queries and it will go up
Also what is the size of your DB?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[chatridge]

We have about a dozen databases on that server ranging from a couple MB each up to 50GB. If I don't have my memory configured as dynamic, wouldn't task manager show sqlserver using the full allocated amount?

 

[mrdenny]

Task manager won't report the correct amount of memory being used by the SQL Server process. Check the total amount used on the performance tab.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com