I just got to know that the RAM is going to be increased to 6 GB on the
target server before it goes into Production. How does it affect the /PAE or
the /3GB switch in boot.ini file and the AWE enabled / disabled on SQL Server?

Thanks in advance.

"ronnie" wrote:

> Thanks a lot Tom for the quick response. Can you please explain the reason
> why you want to have that change so that I can have a better understanding of
> what's going on? Also, the target server has a Windows 2003 server in
> comparison to the current server that is running on Windows 2000 server.
>
> What would happen if the AWE is enabled? Thanks in advance.
>
> "Tom Moreau" wrote:
>
> > Your target BOOT.INI has the /PAE switch enabled. Remove it and use /3GB.
> >
> > --
> > Tom
> >
> > ----------------------------------------------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> > SQL Server MVP
> > Toronto, ON Canada
> > https://mvp.support.microsoft.com/profile/Tom.Moreau
> >
> >
> > "ronnie" <ronnie@discussions.microsoft.com> wrote in message
> > news:C14D97C4-6190-4632-9A7B-D619F992B5CB@microsoft.com...
> > Hi,
> >
> > I am moving the default instance of a SQL Server 2000 to a ESX Server
> > running on VMWare. Below are the specifications:
> >
> > Current Server:
> >
> > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > Windows Advanced Server 2000 SP4
> > Intel Pentium III 1400 MHz
> > 4 GB RAM
> > /3 GB switch enabled in boot.ini
> > AWE not enabled and SQL Server using a maximum of 3 GB of RAM.
> >
> >
> > Target Server:
> >
> > SQL Server 2000 Enterprise Edition Version 8.00.2187
> > Windows Server 2003 Enterprise Edition SP2
> > Intel Xeon X7350 2.93 GHz
> > 3.75 GB RAM
> > /PAE 3 GB switch enabled in boot.ini
> > AWE not enabled
> >
> > The target server is running on VMWare and we will be adding more memory to
> > it if it is needed in the future. What AWE setting should I be using on the
> > target machine?
> >
> >