3 GB switch boot.ini

Hello all,
Looking for opinions on setting the 3GB switch in the
boot.ini for a server running WIN2k Standard sp3
with SQL Server 2000 EE sp3a.
There is 3 GB of physical RAM.
TIA,
JoeGo ahead, there is no down side.
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Joe" <Joe.Hellsten@.valero.com> wrote in message
news:03c601c361db$fbd37fe0$a501280a@.phx.gbl...
> Hello all,
> Looking for opinions on setting the 3GB switch in the
> boot.ini for a server running WIN2k Standard sp3
> with SQL Server 2000 EE sp3a.
> There is 3 GB of physical RAM.
>
> TIA,
> Joe

3 GB Switch

If I have a server with 4GB of RAM and I am running SQL
Server 2k Standard edition (which support up to 2GB of
RAM) does it help anything to utilize the 3 GB switch.Hi
You should use performance monitor to check your memory usage before making
any changes. In general if the server is only running SQL Server it would
probably not be of benefit.
John
"JI" <jidawgs@.hotmail.com> wrote in message
news:04fc01c3d6bf$ba7ede00$a001280a@.phx.gbl...
> If I have a server with 4GB of RAM and I am running SQL
> Server 2k Standard edition (which support up to 2GB of
> RAM) does it help anything to utilize the 3 GB switch.