Solved

Clustering on Windows 2003 SP2 Enterprise with SQL Server 2008

Posted on 2013-05-14
2
249 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
Comment Utility
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
Comment Utility
Resource depleted was virtual memory caused by 3rd party drivers.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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,…
Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

743 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now