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?

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?

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?
>
>

What was referring to was this:

"/PAE 3 GB switch enabled in boot.ini"

It is self-contradictory. /PAE is not 3GB.

Also, you don't have enough memory to take advantage of 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:FCBE95A4-E3E6-4FCE-9548-090B812D9EB6@microsoft.com...
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?
>
>

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?
> >
> >

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?
> >
> >

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?
> > >
> > >
>
>

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?
> > >
> > >
>
>