Wednesday, March 28, 2012

Memory - Windows 2k3 Ent Ed, SQL 2k Ent Ed Version 2040

This is my environment:
Memory - Windows 2k3 Ent Ed, SQL 2k Ent Ed Version 2040
Have a total of 8 GB of memory.
Should I do the following ?
1. /3GB
2. /PAE
3. Enable AWE in SQL Server
Thanks,
RangaHello,
To make use of the extended memory, please modify the Boot.ini and enable
the AWE option. Make sure that apart from these you need to
make the SQL Server memory parameter static.
Take a look into below URL:-
http://support.microsoft.com/kb/274750
Thanks
Hari
"Ranga" <Ranga@.discussions.microsoft.com> wrote in message
news:617459F8-8E93-4687-AF1A-4B7175D7E9AA@.microsoft.com...
> This is my environment:
> Memory - Windows 2k3 Ent Ed, SQL 2k Ent Ed Version 2040
> Have a total of 8 GB of memory.
> Should I do the following ?
> 1. /3GB
> 2. /PAE
> 3. Enable AWE in SQL Server
> Thanks,
> Ranga

No comments:

Post a Comment