Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to find cause of failover in clustering? Expand / Collapse
Author
Message
Posted Monday, September 16, 2013 6:58 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:04 AM
Points: 416, Visits: 2,540
Hi All,

I have a 2 node cluster with active/passive configuration and I have 2 instances running on active node.
However, for the past few weeks, the instances were failing over to second node and I am trying to find the cause for it.

Could be due some resource contention, but I am anxious to find out how do you go about gathering/troubleshooting this scenario.

Please share your experience.


Regards,
SQLisAwe5oMe.
Post #1495344
Posted Tuesday, September 17, 2013 5:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:51 AM
Points: 6,350, Visits: 13,674
refer to the cluster events console and the app and sys event logs for more info

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1495450
Posted Tuesday, September 17, 2013 8:03 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:04 AM
Points: 416, Visits: 2,540
Perry Whittle (9/17/2013)
refer to the cluster events console and the app and sys event logs for more info


cluster events console, can you tell me how can I access this event console?


Regards,
SQLisAwe5oMe.
Post #1495515
Posted Tuesday, September 17, 2013 10:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:51 AM
Points: 6,350, Visits: 13,674
Open fail over cluster manager and view cluster events there

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1495576
Posted Tuesday, September 17, 2013 11:01 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:04 AM
Points: 416, Visits: 2,540
Perry Whittle (9/17/2013)
Open fail over cluster manager and view cluster events there


When I open the cluster Events it's blank....it says " no query is defined.


Regards,
SQLisAwe5oMe.
Post #1495592
Posted Tuesday, September 17, 2013 11:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:51 AM
Points: 6,350, Visits: 13,674
Yes you have to create a new query

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1495606
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse