 | |
About Upgrade RAM on SQL 2000 Cluster
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
About Upgrade RAM on SQL 2000 Cluster -
09-14-2004
, 05:11 AM
#2
| |||
| |||
|
#3
| |||
| |||
|
|
unless you had previously set the max memory. |
i found this article
http://support.microsoft.com/?id=274750
This can help me ?
"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote
Quote:
|
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 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 -- --- |
#4
| |||
| |||
|
|
unless you had previously set the max memory. |
i found this article
http://support.microsoft.com/?id=274750
This can help me ?
"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote
Quote:
|
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 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 -- --- |
#5
| |||
| |||
|
|
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 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 (AT) dont (DOT) spam.me.cips.ca> wrote in message news:uMuKU9kmEHA.3392 (AT) TK2MSFTNGP15 (DOT) 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 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 -- --- |
#6
| |||
| |||
|
|
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 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 (AT) dont (DOT) spam.me.cips.ca> wrote in message news:uMuKU9kmEHA.3392 (AT) TK2MSFTNGP15 (DOT) 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 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 -- --- |
#7
| |||
| |||
|
|
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 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 (AT) dont (DOT) spam.me.cips.ca> wrote in message news:OEawkLlmEHA.2552 (AT) TK2MSFTNGP11 (DOT) phx.gbl... 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 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 (AT) dont (DOT) spam.me.cips.ca> wrote in message news:uMuKU9kmEHA.3392 (AT) TK2MSFTNGP15 (DOT) 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 (AT) TK2MSFTNGP14 (DOT) 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 -- --- |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.