Earlier, you said "the RAM is going to be increased to 6 GB". So does the
server have that much physical RAM now? If not, then wait until you have it
before turning on AWE.
--
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:B23DEDE0-4CE2-4119-BC6F-BB632C5FAE15@microsoft.com...
Hi Tom,
I have put in both the /PAE and /3GB switches as you suggested. Now the SQL
Server is only using 3GB of memory. I want the SQL server to use 5 GB out of
6 GB of memory and leave the 1 GB memory for the OS. How can I achieve this?
Thanks in advance.
"Tom Moreau" wrote:
> That's different. In That case, I'd turn on both - once you get the extra
> memory. Above 12GB, remove the /3GB switch:
>
>
http://groups.google.ca/group/micros...83b85ef5b91530
>
> --
> 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:051D8B41-A6F2-49FA-93A4-4DE697956DEC@microsoft.com...
> 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?
> > >
> > >
>
>