dbTalk Databases Forums  

Failover Nodes - Varying Hardware

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Failover Nodes - Varying Hardware in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Randy
 
Posts: n/a

Default Failover Nodes - Varying Hardware - 04-08-2009 , 11:36 AM






We are replacing one SQL 2000 cluster node. The existing two nodes have 4GB
with the /3GB switch - no PAE. AWE is not enabled. The new node will have
15.2 GB with PAE. Should I still use the /3GB switch even though there is
more than 8 GB?

Thanks,
Randy


Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Failover Nodes - Varying Hardware - 04-08-2009 , 11:59 AM






To answer your question, /3GB should stop at no higher than 12 GB.

As for replacing cluster nodes with asymmetrical hardware, that is not
supported on Windows 2000/2003. There are very good technical reasons why
matched HCL-listed hardware is required.

Then again, with SQL 2000, you are pretty much out of support anyway.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote

Quote:
We are replacing one SQL 2000 cluster node. The existing two nodes have
4GB
with the /3GB switch - no PAE. AWE is not enabled. The new node will
have
15.2 GB with PAE. Should I still use the /3GB switch even though there is
more than 8 GB?

Thanks,
Randy



Reply With Quote
  #3  
Old   
Randy
 
Posts: n/a

Default Re: Failover Nodes - Varying Hardware - 04-08-2009 , 01:35 PM



Thanks. I will not use the switch and suggest we replace both nodes, not
just the bad one. Unfortunately, the active node had been patched and
requires a reboot. I can't add a new nodes until it's rebooted. Looks like
we are going to be down.

"Geoff N. Hiten" wrote:

Quote:
To answer your question, /3GB should stop at no higher than 12 GB.

As for replacing cluster nodes with asymmetrical hardware, that is not
supported on Windows 2000/2003. There are very good technical reasons why
matched HCL-listed hardware is required.

Then again, with SQL 2000, you are pretty much out of support anyway.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote in message
news:CE912B74-5E2C-4EDF-A8CE-953B2767A69C (AT) microsoft (DOT) com...
We are replacing one SQL 2000 cluster node. The existing two nodes have
4GB
with the /3GB switch - no PAE. AWE is not enabled. The new node will
have
15.2 GB with PAE. Should I still use the /3GB switch even though there is
more than 8 GB?

Thanks,
Randy




Reply With Quote
  #4  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Failover Nodes - Varying Hardware - 04-08-2009 , 02:13 PM



One more reason to go to SQL 2008. Everything is rolling upgrades. One or
two failovers is all it takes.

--GNH


"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote

Quote:
Thanks. I will not use the switch and suggest we replace both nodes, not
just the bad one. Unfortunately, the active node had been patched and
requires a reboot. I can't add a new nodes until it's rebooted. Looks
like
we are going to be down.

"Geoff N. Hiten" wrote:

To answer your question, /3GB should stop at no higher than 12 GB.

As for replacing cluster nodes with asymmetrical hardware, that is not
supported on Windows 2000/2003. There are very good technical reasons
why
matched HCL-listed hardware is required.

Then again, with SQL 2000, you are pretty much out of support anyway.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote in message
news:CE912B74-5E2C-4EDF-A8CE-953B2767A69C (AT) microsoft (DOT) com...
We are replacing one SQL 2000 cluster node. The existing two nodes
have
4GB
with the /3GB switch - no PAE. AWE is not enabled. The new node will
have
15.2 GB with PAE. Should I still use the /3GB switch even though there
is
more than 8 GB?

Thanks,
Randy





Reply With Quote
  #5  
Old   
Randy
 
Posts: n/a

Default Re: Failover Nodes - Varying Hardware - 04-08-2009 , 02:45 PM



One of these days.... Thanks.

"Geoff N. Hiten" wrote:

Quote:
One more reason to go to SQL 2008. Everything is rolling upgrades. One or
two failovers is all it takes.

--GNH


"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote in message
news:7D039071-13A9-4732-B59A-DD140B7C7F53 (AT) microsoft (DOT) com...
Thanks. I will not use the switch and suggest we replace both nodes, not
just the bad one. Unfortunately, the active node had been patched and
requires a reboot. I can't add a new nodes until it's rebooted. Looks
like
we are going to be down.

"Geoff N. Hiten" wrote:

To answer your question, /3GB should stop at no higher than 12 GB.

As for replacing cluster nodes with asymmetrical hardware, that is not
supported on Windows 2000/2003. There are very good technical reasons
why
matched HCL-listed hardware is required.

Then again, with SQL 2000, you are pretty much out of support anyway.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Randy" <Randy (AT) discussions (DOT) microsoft.com> wrote in message
news:CE912B74-5E2C-4EDF-A8CE-953B2767A69C (AT) microsoft (DOT) com...
We are replacing one SQL 2000 cluster node. The existing two nodes
have
4GB
with the /3GB switch - no PAE. AWE is not enabled. The new node will
have
15.2 GB with PAE. Should I still use the /3GB switch even though there
is
more than 8 GB?

Thanks,
Randy






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.