Solved

Clustering on Windows 2003 SP2 Enterprise with SQL Server 2008

Posted on 2013-05-14
2
256 Views
Last Modified: 2013-06-24
Hello,

Scenario - clustered SQL (node A active, node B is passive). OS is Windows 2003 Enterprise SP2 and SQL is SQL 2008.

Situation - node A hung due to resource depletion - server did not reboot. For some reason, node A didn't failover to node B. Microsoft is telling me that is a normal behavior...isn't that defeats the purpose of clustering??

Can someone please enlighten me?
0
Comment
Question by:syseng007
2 Comments
 
LVL 22

Accepted Solution

by:
65td earned 500 total points
ID: 39166192
MS quote:
•A failover cluster provides high availability for services, applications, and other resources through an architecture that maintains a consistent image of the cluster on all nodes and that allows nodes to transfer resource ownership on demand

What resource became depleted?

Usually clustering fails over on active node hard failures, lose of public network.
0
 

Author Comment

by:syseng007
ID: 39166269
Resource depleted was virtual memory caused by 3rd party drivers.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

by Batuhan Cetin In this article I will be guiding through the process of removing a failed DC metadata from Active Directory (hereafter, AD) using the ntdsutil tool in a Windows Server 2003 environment. These steps are not necessary in a Win…
I guess it is not common knowledge to most Wintel engineers/administrators: If you have an SNMP-based monitoring system in your environment (and it's common to have SNMP or Syslog) it's reasonably easy to enable monitoring of the Windows Event logs,…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question