/3GB SQL Server 2000

Hi,
I run SQL Server 2000 on Windows 2000 Server (4 GB memory) with 2
instances.
As I understand it, one instance can use a maximum of 2 GB of memory. If I
would use the /3GB switch in this environment, would that help me or is it
that this switch can only be used with the Advanced or Enterprise Edition
of SQL Server 2000 /w2K?
TIA
WombelYou need to run Windows 2000 Advanced Server or Data Center editions in
order to use the /3GB switch. See
http://support.microsoft.com/defaul...750&Product=sql
for more information.
Assuming you want both instances to use an equal amount of memory, you
wouldn't want to use /3GB anyway with only 4GB physical RAM. It's important
to have enough physical RAM to support the SQL Server memory requirements of
all instances running on the server.
Hope this helps.
Dan Guzman
SQL Server MVP
"Thomas Wrobel" <twrobel@.waslos.de> wrote in message
news:Xns94C3739FDCBEBtwrobelwaslosde@.207
.46.248.16...
> Hi,
> I run SQL Server 2000 on Windows 2000 Server (4 GB memory) with 2
> instances.
> As I understand it, one instance can use a maximum of 2 GB of memory. If I
> would use the /3GB switch in this environment, would that help me or is it
> that this switch can only be used with the Advanced or Enterprise Edition
> of SQL Server 2000 /w2K?
> TIA
> Wombel|||"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in
news:OrPWjb9GEHA.684@.tk2msftngp13.phx.gbl:

> You need to run Windows 2000 Advanced Server or Data Center editions
> in order to use the /3GB switch. See
> http://support.microsoft.com/defaul...274750&Product=
> sql for more information.
> Assuming you want both instances to use an equal amount of memory, you
> wouldn't want to use /3GB anyway with only 4GB physical RAM. It's
> important to have enough physical RAM to support the SQL Server memory
> requirements of all instances running on the server.
>
Dan,
thanks for your reply. Do you know if there is any difference when I user
Windows 2003 Server Standard?
TIA
Thomas|||> thanks for your reply. Do you know if there is any difference when I user
> Windows 2003 Server Standard?
As stated in MSKB 274750, you can use the /3GB boot.ini switch with Windows
2000 Server (Standard Edition).
Hope this helps.
Dan Guzman
SQL Server MVP
"Thomas Wrobel" <twrobel@.waslos.de> wrote in message
news:Xns94C39FB4C54Etwrobelwaslosde@.207.46.248.16...
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in
> news:OrPWjb9GEHA.684@.tk2msftngp13.phx.gbl:
>
> Dan,
> thanks for your reply. Do you know if there is any difference when I user
> Windows 2003 Server Standard?
> TIA
> Thomassql