About Upgrade RAM on SQL 2000 Cluster

Hi all,
i must upgrade the RAM from 2 GB to 4 GB on the Windows 2000 ADV Cluster A/P
on both node. There is any problem with the cluster service or SQL to do it
?
May i do it first on the passive node , swith istance on the passive (now
active) node and upgrade the passive node (previous active) !?!?!
After i upgrade the RAM may i set a /3g swith i boot.ini for permit SQL
Server to use 3 GB RAM ?
There is any SQL configuration after upgrade the RAM ?
Thanks in advance
--
That's pretty much how it's done. There should be no SQL Server
configuration required, unless you had previously set the max memory.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
<io.com> wrote in message news:O%230P0MkmEHA.3340@.TK2MSFTNGP14.phx.gbl...
Hi all,
i must upgrade the RAM from 2 GB to 4 GB on the Windows 2000 ADV Cluster A/P
on both node. There is any problem with the cluster service or SQL to do it
?
May i do it first on the passive node , swith istance on the passive (now
active) node and upgrade the passive node (previous active) !?!?!
After i upgrade the RAM may i set a /3g swith i boot.ini for permit SQL
Server to use 3 GB RAM ?
There is any SQL configuration after upgrade the RAM ?
Thanks in advance
--
|||Hi , thanks for your reply!

>unless you had previously set the max memory.
I previously not configured a max memory but how i do it ?
i found this article
http://support.microsoft.com/?id=274750
This can help me ?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uMuKU9kmEHA.3392@.TK2MSFTNGP15.phx.gbl...
> That's pretty much how it's done. There should be no SQL Server
> configuration required, unless you had previously set the max memory.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> <io.com> wrote in message news:O%230P0MkmEHA.3340@.TK2MSFTNGP14.phx.gbl...
> Hi all,
> i must upgrade the RAM from 2 GB to 4 GB on the Windows 2000 ADV Cluster
A/P
> on both node. There is any problem with the cluster service or SQL to do
it
> ?
> May i do it first on the passive node , swith istance on the passive (now
> active) node and upgrade the passive node (previous active) !?!?!
> After i upgrade the RAM may i set a /3g swith i boot.ini for permit SQL
> Server to use 3 GB RAM ?
> There is any SQL configuration after upgrade the RAM ?
> Thanks in advance
>
>
> --
> --
>
|||I meant within SQL Server. Check out sp_configure in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
<io.com> wrote in message news:%23ieRVJlmEHA.324@.TK2MSFTNGP11.phx.gbl...
Hi , thanks for your reply!

>unless you had previously set the max memory.
I previously not configured a max memory but how i do it ?
i found this article
http://support.microsoft.com/?id=274750
This can help me ?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:uMuKU9kmEHA.3392@.TK2MSFTNGP15.phx.gbl...
> That's pretty much how it's done. There should be no SQL Server
> configuration required, unless you had previously set the max memory.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> <io.com> wrote in message news:O%230P0MkmEHA.3340@.TK2MSFTNGP14.phx.gbl...
> Hi all,
> i must upgrade the RAM from 2 GB to 4 GB on the Windows 2000 ADV Cluster
A/P
> on both node. There is any problem with the cluster service or SQL to do
it
> ?
> May i do it first on the passive node , swith istance on the passive (now
> active) node and upgrade the passive node (previous active) !?!?!
> After i upgrade the RAM may i set a /3g swith i boot.ini for permit SQL
> Server to use 3 GB RAM ?
> There is any SQL configuration after upgrade the RAM ?
> Thanks in advance
>
>
> --
> --
>
|||Thanks Tom !
i have only the last question :
if i to leave a default value sqlserver may allocate 3 Gb RAM ?
Thanks
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OEawkLlmEHA.2552@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> I meant within SQL Server. Check out sp_configure in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> <io.com> wrote in message news:%23ieRVJlmEHA.324@.TK2MSFTNGP11.phx.gbl...
> Hi , thanks for your reply!
>
> I previously not configured a max memory but how i do it ?
> i found this article
> http://support.microsoft.com/?id=274750
> This can help me ?
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uMuKU9kmEHA.3392@.TK2MSFTNGP15.phx.gbl...
news:O%230P0MkmEHA.3340@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> A/P
do[vbcol=seagreen]
> it
(now
>
|||Just use the defaults and SQL Server will use up to 3GB - if you have the
/3GB switch in the BOOT.INI.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
<io.com> wrote in message news:OzJxndlmEHA.744@.TK2MSFTNGP10.phx.gbl...
Thanks Tom !
i have only the last question :
if i to leave a default value sqlserver may allocate 3 Gb RAM ?
Thanks
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OEawkLlmEHA.2552@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> I meant within SQL Server. Check out sp_configure in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> <io.com> wrote in message news:%23ieRVJlmEHA.324@.TK2MSFTNGP11.phx.gbl...
> Hi , thanks for your reply!
>
> I previously not configured a max memory but how i do it ?
> i found this article
> http://support.microsoft.com/?id=274750
> This can help me ?
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:uMuKU9kmEHA.3392@.TK2MSFTNGP15.phx.gbl...
news:O%230P0MkmEHA.3340@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> A/P
do[vbcol=seagreen]
> it
(now
>
|||thanks.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23R1aihlmEHA.324@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Just use the defaults and SQL Server will use up to 3GB - if you have the
> /3GB switch in the BOOT.INI.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> <io.com> wrote in message news:OzJxndlmEHA.744@.TK2MSFTNGP10.phx.gbl...
> Thanks Tom !
> i have only the last question :
> if i to leave a default value sqlserver may allocate 3 Gb RAM ?
> Thanks
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:OEawkLlmEHA.2552@.TK2MSFTNGP11.phx.gbl...
> news:O%230P0MkmEHA.3340@.TK2MSFTNGP14.phx.gbl...
Cluster[vbcol=seagreen]
> do
> (now
SQL
>