Available Memory

[Aluminum]

I have AWE enabled on a SQL/Server. When I go into task manager, the majority of memory is free. Is there any way to make SQL Server utilize more available memory. I checked SP_CONFIG and the memory management tab in server properties. Both are configired correctly.

 

[drtree]

Hey - what version of Windows/SQL Server are you running? Here's a good article -

http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx

HTH,

Doc Tree

 

[ptheriault]

did you put the \pae switch in the boot ini file? What version of windows and SQL are you on?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Aluminum]

I am on version 2000 with AWE enabled. Still having the issue.

 

[drtree]

Hey man - what specific versions of SQL Server and Windows 2000 are you using? They bought a server here to use SQL Server (with AWE)...unfortunately they got the Standard Edition!

Doc Tree

 

[mrdenny]

What is the majority mean. How much ram is installed, what is SQL configured to use? What edition of SQL and Windows are installed?

There is no way to force SQL to use more memory. It will use the memory that it needs to up until it runs out of physical memory, hits the settings which you have defined (either on purpose or though incorrect configuration), or it hits it's licensing limitations.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

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

http://www.mrdenny.com