Memory usage SQL SERVER ENTERPRISE EDITION

Hi,
I have SQL SERVER enterprise edition on MIcrosoft windows 2003
enterprise.and we have about 4GB of RAM on it...also I have enabled
AWE...still SQL Server not using more then 1.86GB...
Do i have to use anything for SQL server to use more memory or SQL server
will use what it needs
Any suggestion appreciated
- NT
Did you modify the boot.ini to include /3GB and /PAE?
Keith
"NT" <NT@.discussions.microsoft.com> wrote in message
news:4ABC910A-7853-4BC4-B751-A66C9FA8C9E7@.microsoft.com...
> Hi,
> I have SQL SERVER enterprise edition on MIcrosoft windows 2003
> enterprise.and we have about 4GB of RAM on it...also I have enabled
> AWE...still SQL Server not using more then 1.86GB...
> Do i have to use anything for SQL server to use more memory or SQL server
> will use what it needs
> Any suggestion appreciated
> --
> - NT
|||Enabling AWE with 4GB of ram is pretty much useless. You can set the /3GB
switch in the boot.ini file to allow SQL Server to use 3GB but it is best to
leave the rest for the OS and other apps that will need to run on the
server.
Andrew J. Kelly SQL MVP
"NT" <NT@.discussions.microsoft.com> wrote in message
news:4ABC910A-7853-4BC4-B751-A66C9FA8C9E7@.microsoft.com...
> Hi,
> I have SQL SERVER enterprise edition on MIcrosoft windows 2003
> enterprise.and we have about 4GB of RAM on it...also I have enabled
> AWE...still SQL Server not using more then 1.86GB...
> Do i have to use anything for SQL server to use more memory or SQL server
> will use what it needs
> Any suggestion appreciated
> --
> - NT
|||Thanks for the ...ACTUALLY WE HAVE 8GB RAM...
We have put /3GB /PAE in our boot.ini...we will reboot server tonight...
Does this will help SQL server to use more then 2GB? correct?
Thanks
"Andrew J. Kelly" wrote:

> Enabling AWE with 4GB of ram is pretty much useless. You can set the /3GB
> switch in the boot.ini file to allow SQL Server to use 3GB but it is best to
> leave the rest for the OS and other apps that will need to run on the
> server.
> --
> Andrew J. Kelly SQL MVP
>
> "NT" <NT@.discussions.microsoft.com> wrote in message
> news:4ABC910A-7853-4BC4-B751-A66C9FA8C9E7@.microsoft.com...
>
>
|||Flags for memory usage
System memory Flag to add to boot.ini file
4GB /3GB
8GB /3GB /PAE
16GB /3GB /PAE
16-64GB /PAE
/3GB limitS OS memory to 1GB and is optional.
When max memory >16GB, OS needs more than 1GB since it needs to manage AWE,
therefore /3GB can not be used there.
/PAE enables the use of memory more than 3GB.
In such situation, AWE also needs to be enabled by
run the following in QA:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144 --(6144 the number of memory for SQL
Server in MB)
RECONFIGURE
GO
"NT" <NT@.discussions.microsoft.com> wrote in message
news:CD4C56E5-8558-4979-AB24-1477CB7D5A6E@.microsoft.com...[vbcol=seagreen]
> Thanks for the ...ACTUALLY WE HAVE 8GB RAM...
> We have put /3GB /PAE in our boot.ini...we will reboot server tonight...
> Does this will help SQL server to use more then 2GB? correct?
> Thanks
> "Andrew J. Kelly" wrote:
/3GB[vbcol=seagreen]
best to[vbcol=seagreen]
server[vbcol=seagreen]
|||THe /3GB lets SQL Server (or any application) up to 3GB of directly
addressable memory and gives the OS 1GB. It does not allow you to address
more than 3GB that is what AWE and PAE are for. Just remember that if you
do turn on AWE you set your max memory to an amount less than the max since
AWE is not dynamic and will not play well with the OS if you grab all the
memory.
Andrew J. Kelly SQL MVP
"NT" <NT@.discussions.microsoft.com> wrote in message
news:CD4C56E5-8558-4979-AB24-1477CB7D5A6E@.microsoft.com...[vbcol=seagreen]
> Thanks for the ...ACTUALLY WE HAVE 8GB RAM...
> We have put /3GB /PAE in our boot.ini...we will reboot server tonight...
> Does this will help SQL server to use more then 2GB? correct?
> Thanks
> "Andrew J. Kelly" wrote:
/3GB[vbcol=seagreen]
best to[vbcol=seagreen]
server[vbcol=seagreen]