We help IT Professionals succeed at work.

performance of cluster failover (Active to active)

209 Views
Last Modified: 2012-05-08
Let's say there are 2 nodes on a cluster both with same number of processors and same GB of Ram, and they are well utilized.

If there is a failover from an active node NodeA to another active node NodeB (and thus making NodeB carry 2 instances now), what are the concerns for NodeB performance.
Comment
Watch Question

Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
>> If there is a failover from an active node NodeA to another active node NodeB

Shall I assume based on your statements, that you have a Load balanced Cluster failover with both NodeA and NodeB active all times..

If then, then this clustering is just for Load Balancing and would have split load between NodeA and NodeB..

If any one node fails say NodeA, then NodeB would carry the entire load..

>> what are the concerns for NodeB performance.

Since it is taking entire load, it depends upon your peak load and server resources available..

Author

Commented:
Sorry for not telling it clear. No, it is actually Active-active-passive structure. So it is not load balanced.

Author

Commented:
since our cluster service is not load-aware, instead of going to NodeC, the instance went to NodeB.

For example, if both nodes need 12 GB of RAM to operate smoothly with their own instances, and now one node is carrying two. We do not want to do the failback until a particular time, because the server availability is time-sensitive critical. So wondering which will be more costly - to wait till the particular time to do the failback or do the failback now to save the resources for the instances?
SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
This comment came while I was typing for my comment.

>> since our cluster service is not load-aware, instead of going to NodeC, the instance went to NodeB.

As I mentioned earlier, additional nodes are just Backup nodes..
They will not help you with your load sharing or anything..

hope this clarifies.

Author

Commented:
rrjegan17
Thanks for the reference. But out setup is not load smart. That is why we have 2 nodes empty and one node with 2 instances. I guess there is no way to make sure that it will always be load balanced.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

Commented:
Welcome..

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.