September 16, 2013 at 6:58 pm
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.
September 17, 2013 at 5:26 am
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" 😉
September 17, 2013 at 8:03 am
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.
September 17, 2013 at 10:26 am
Open fail over cluster manager and view cluster events there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2013 at 11:01 am
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.
September 17, 2013 at 11:39 am
Yes you have to create a new query
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply