Re: Memory Question

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 14:53:54 -0500

You should leave the /3GB in either way but if you want to use more than 4GB
for SQL Server you must turn on AWE. The memory settings you are refereeing
to default to what the OS sees and not necessarily what SQL Server can
actually use. If you turn on AWE you can use all of it but you then need to
set the MAX Memory setting to about 7GB or so. Otherwise SQL server will
take all of the memory as it is not dynamic when using AWE. 

-- 
Andrew J. Kelly  SQL MVP
"Jag" <Jag@discussions.microsoft.com> wrote in message 
news:0ED37B31-6A40-40FC-8BC7-C241E96DD662@microsoft.com...
>I have Windows 2003 Enterprise Server with SQL 2000 Enterprise Editon.
> The server is a Quad 3.2 system with 7GB of ram.
>
> Right now I have in the boot.ini both the /PAE and the /3GB switch.
> AWE is dissabled at the moment.
>
> When I look at memory under properties in SQL Enterprise Manager, for the
> SQL server it is set to dynamic and it shows a min. of 0 and a max of 
> 6911.
>
> When I look at perfmon SQL Memory Manager counters Total and Target memory
> it shows 2818712.  This I assume is because of the /3GB switch which gives
> 3GB of the lower 4 GB to SQL.
>
> My question is how does the memory settings under the properties of the
> server in SQL enterprise manger fit into the memory equation.  Is this the
> AWE settings or is this something completly different?
>
> I have had some people tell me that I should leave /3GB in the boot.ini
> while others have told me to take it out and enalbe AWE.

Relevant Pages

  • Re: Locking pages in memory
    ... So I think the 64-bit Standard does not support locked pages in memory. ... Rick Byham, SQL Server Books Online ...
    (microsoft.public.sqlserver.setup)
  • Re: Allocating more memory to sql server
    ... Are you sure the AWE was set correctly? ... > for SQL server Targer Sever memory and Total Server Memory, ... YOu should not use Task Manager to monitor memory for>> SQL Server. ... >>> windows task manager total physical memory shows as memory usage ...
    (microsoft.public.sqlserver.setup)
  • Re: How to correctly use /PAE and AWE
    ... The /3GB gives SQL Server access to an extra GB of physical memory vs AWE ... >> Set Working Size configuration options how would I determine appropriate ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server user 2GB> ram
    ... Because SQL Server does not grap that whole 6GB of memory as soon as you set it and Total Server Memory will show how much memory SQL Server consumes at that moment. ... I have enable the AWE using the following scripts: ...
    (microsoft.public.sqlserver.setup)
  • Re: Locking pages in memory
    ... the account SQL runs under) the permission to lock pages in memory. ... Server Standard, Enterprise, and Developer editions: Required for SQL Server ...
    (microsoft.public.sqlserver.setup)