PAE & AWE Question

Hello:
I am evaluating performance issues on a SQL server and trying to understand
when to use the PAE switch.
I have a Windows 2000 Advanced server SP4 running MS SQL Server Enterprise
Edition SP4. The server has 4GB total physical RAM. Do I need to configure
PAE/AWE for SQL to take advantage of more than 2GB of RAM?
SQL services fail at times due to high memory utilization. Any assistance
would be appreciated!
Thanks,
WHello,
If your server has only 4GB of memory you can not use AWE. By default
Windows uses 2 GB and SQL Server can use the remaining 2 GB. By adding the
/3GB switch to the Windows boot.ini file you can have Windows to use only 1
GB so SQL Server can use the remaining 3 GB.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Walid" wrote:
> Hello:
> I am evaluating performance issues on a SQL server and trying to understand
> when to use the PAE switch.
> I have a Windows 2000 Advanced server SP4 running MS SQL Server Enterprise
> Edition SP4. The server has 4GB total physical RAM. Do I need to configure
> PAE/AWE for SQL to take advantage of more than 2GB of RAM?
> SQL services fail at times due to high memory utilization. Any assistance
> would be appreciated!
> Thanks,
> W|||If you visit the following link, you'll understand PAE better.
http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx
And for AWE, PAE, 3GB:
http://support.microsoft.com/kb/274750/en-us
--
Ekrem Ã?nsoy
"Walid" <Walid@.discussions.microsoft.com> wrote in message
news:350CF984-8737-43F6-8570-189A7C81AFFD@.microsoft.com...
> Hello:
> I am evaluating performance issues on a SQL server and trying to
> understand
> when to use the PAE switch.
> I have a Windows 2000 Advanced server SP4 running MS SQL Server Enterprise
> Edition SP4. The server has 4GB total physical RAM. Do I need to
> configure
> PAE/AWE for SQL to take advantage of more than 2GB of RAM?
> SQL services fail at times due to high memory utilization. Any assistance
> would be appreciated!
> Thanks,
> W|||Thank you all very much for the info!!
"Ekrem Ã?nsoy" wrote:
> If you visit the following link, you'll understand PAE better.
> http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx
> And for AWE, PAE, 3GB:
> http://support.microsoft.com/kb/274750/en-us
> --
> Ekrem Ã?nsoy
>
> "Walid" <Walid@.discussions.microsoft.com> wrote in message
> news:350CF984-8737-43F6-8570-189A7C81AFFD@.microsoft.com...
> > Hello:
> > I am evaluating performance issues on a SQL server and trying to
> > understand
> > when to use the PAE switch.
> >
> > I have a Windows 2000 Advanced server SP4 running MS SQL Server Enterprise
> > Edition SP4. The server has 4GB total physical RAM. Do I need to
> > configure
> > PAE/AWE for SQL to take advantage of more than 2GB of RAM?
> >
> > SQL services fail at times due to high memory utilization. Any assistance
> > would be appreciated!
> >
> > Thanks,
> >
> > W
>|||> If your server has only 4GB of memory you can not use AWE.
Not true. See
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx
Linchi
"Ben Nevarez" wrote:
> Hello,
> If your server has only 4GB of memory you can not use AWE. By default
> Windows uses 2 GB and SQL Server can use the remaining 2 GB. By adding the
> /3GB switch to the Windows boot.ini file you can have Windows to use only 1
> GB so SQL Server can use the remaining 3 GB.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Walid" wrote:
> > Hello:
> > I am evaluating performance issues on a SQL server and trying to understand
> > when to use the PAE switch.
> >
> > I have a Windows 2000 Advanced server SP4 running MS SQL Server Enterprise
> > Edition SP4. The server has 4GB total physical RAM. Do I need to configure
> > PAE/AWE for SQL to take advantage of more than 2GB of RAM?
> >
> > SQL services fail at times due to high memory utilization. Any assistance
> > would be appreciated!
> >
> > Thanks,
> >
> > W|||Again, a nice work by Linchi... Thanks.
--
Ekrem Ã?nsoy
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:10FB2A3A-4BA1-4118-B376-D65B96BEB5D7@.microsoft.com...
>> If your server has only 4GB of memory you can not use AWE.
> Not true. See
> http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx
> Linchi
> "Ben Nevarez" wrote:
>> Hello,
>> If your server has only 4GB of memory you can not use AWE. By default
>> Windows uses 2 GB and SQL Server can use the remaining 2 GB. By adding
>> the
>> /3GB switch to the Windows boot.ini file you can have Windows to use only
>> 1
>> GB so SQL Server can use the remaining 3 GB.
>> Hope this helps,
>> Ben Nevarez
>> Senior Database Administrator
>> AIG SunAmerica
>>
>> "Walid" wrote:
>> > Hello:
>> > I am evaluating performance issues on a SQL server and trying to
>> > understand
>> > when to use the PAE switch.
>> >
>> > I have a Windows 2000 Advanced server SP4 running MS SQL Server
>> > Enterprise
>> > Edition SP4. The server has 4GB total physical RAM. Do I need to
>> > configure
>> > PAE/AWE for SQL to take advantage of more than 2GB of RAM?
>> >
>> > SQL services fail at times due to high memory utilization. Any
>> > assistance
>> > would be appreciated!
>> >
>> > Thanks,
>> >
>> > W