Enthusiastic Jones (4/1/2014)
I'm referring to the option in cluster manager where if the agent can't start it causes the instance to failover to another node. I'm trying to see how others have this setup. I know by default that it is on, but should it be?
For the most part it's not an issue. I've set up numerous FCIs with the default settings and not had any problems. If the group is failing over it will be because the resource either cannot restart or because there are an increased number of failures within a specified time period (detailed in the red ellipse).
If you want to stop the group failing over everytime the agent goes down, uncheck the box shown in the blue ellipse.
However, if the agent is really causing this much trouble you should be spending time figuring out why and remedying the situation.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉