AWE and multiple instance

I have a SQL Server 2000 Enterprise server with 16GB of RAM. I have
installed SP4 and the AWE hotfix.
I have 3 instances running on the box:
If I have 1 instance using 7GB and the other 2 are using 4GB each, does
AWE need to be enabled on the instancese which are set to 4GB?
Thanks!
They won't be able to use the 4GB unless you enable AWE for them.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"traceable1" <tracykc@.gmail.com> wrote in message
news:1141139567.679350.285320@.z34g2000cwc.googlegr oups.com...
I have a SQL Server 2000 Enterprise server with 16GB of RAM. I have
installed SP4 and the AWE hotfix.
I have 3 instances running on the box:
If I have 1 instance using 7GB and the other 2 are using 4GB each, does
AWE need to be enabled on the instancese which are set to 4GB?
Thanks!
|||Unless of course they are running on Win2K3 x64. In that case, the SQL2000
instance should be able use up to 4GB without enabling AWE.
Linchi
"Tom Moreau" wrote:

> They won't be able to use the 4GB unless you enable AWE for them.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "traceable1" <tracykc@.gmail.com> wrote in message
> news:1141139567.679350.285320@.z34g2000cwc.googlegr oups.com...
> I have a SQL Server 2000 Enterprise server with 16GB of RAM. I have
> installed SP4 and the AWE hotfix.
> I have 3 instances running on the box:
> If I have 1 instance using 7GB and the other 2 are using 4GB each, does
> AWE need to be enabled on the instancese which are set to 4GB?
> Thanks!
>
|||I just assumed he was on 32-bit hardware, but you raise a good point.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:07C2D7BC-D085-4C5A-BA3D-ED599E571785@.microsoft.com...
Unless of course they are running on Win2K3 x64. In that case, the SQL2000
instance should be able use up to 4GB without enabling AWE.
Linchi
"Tom Moreau" wrote:

> They won't be able to use the 4GB unless you enable AWE for them.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> ..
> "traceable1" <tracykc@.gmail.com> wrote in message
> news:1141139567.679350.285320@.z34g2000cwc.googlegr oups.com...
> I have a SQL Server 2000 Enterprise server with 16GB of RAM. I have
> installed SP4 and the AWE hotfix.
> I have 3 instances running on the box:
> If I have 1 instance using 7GB and the other 2 are using 4GB each, does
> AWE need to be enabled on the instancese which are set to 4GB?
> Thanks!
>
|||One interesting question at that point...
What if had 16GB of RAM and would like to run first instance with 10GB RAM
and another 4 instances with 1GB of RAM each. (all 32 bit).
It's clear that the first one would need AWE, but what about the other 4?
2 of them wouldn't need AWE and they could alocate RAM dynamically right (3
with /3GB in boot.ini)?
But witch two? Is that important?
Would the instances without AWE have to start first and then the rest or
something like that?
Am I thinking in the right way here?
Tom K.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uObHIyKPGHA.1040@.TK2MSFTNGP12.phx.gbl...
>I just assumed he was on 32-bit hardware, but you raise a good point.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:07C2D7BC-D085-4C5A-BA3D-ED599E571785@.microsoft.com...
> Unless of course they are running on Win2K3 x64. In that case, the SQL2000
> instance should be able use up to 4GB without enabling AWE.
> Linchi
> "Tom Moreau" wrote:
>
|||That's an odd requirement. IIRC, up to about 12GB (per instance), you'd go
with both /3GB and /PAE. However, if you have those others that want 1GB,
I'd be sure to limit them explicitly to 1GB. Since they don't use AWE, then
if they start first and then the big instance starts up, I believe the
smaller ones would give up memory (if they're not already limited) to the
one requesting the AWE memory. Once it has its AWE memory, it won't give it
up.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Tom" <mcseman@.hotmail.com> wrote in message
news:u40kZ9KPGHA.648@.TK2MSFTNGP14.phx.gbl...
One interesting question at that point...
What if had 16GB of RAM and would like to run first instance with 10GB RAM
and another 4 instances with 1GB of RAM each. (all 32 bit).
It's clear that the first one would need AWE, but what about the other 4?
2 of them wouldn't need AWE and they could alocate RAM dynamically right (3
with /3GB in boot.ini)?
But witch two? Is that important?
Would the instances without AWE have to start first and then the rest or
something like that?
Am I thinking in the right way here?
Tom K.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uObHIyKPGHA.1040@.TK2MSFTNGP12.phx.gbl...
>I just assumed he was on 32-bit hardware, but you raise a good point.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:07C2D7BC-D085-4C5A-BA3D-ED599E571785@.microsoft.com...
> Unless of course they are running on Win2K3 x64. In that case, the SQL2000
> instance should be able use up to 4GB without enabling AWE.
> Linchi
> "Tom Moreau" wrote:
>