SQL Cluster

Question

SQL Cluster

Veteran Jones

SSC Eights!

Points: 937
More actions
April 1, 2014 at 5:43 am

#287176

Should it be setup so that an instance be set to failover if the SQL Server Agent fails?
Thoughts??

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 233825 More actions · Answer 1

Enthusiastic Jones (4/1/2014)
Should it be setup so that an instance be set to failover if the SQL Server Agent fails?
Thoughts??

The default for this resource is the same as others, initially the cluster service account will attempt to restart the resource on the current node. If persistent failures are encountered the whole group will failover to a partner node.

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

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 2

Enthusiastic Jones (4/1/2014)
Should it be setup so that an instance be set to failover if the SQL Server Agent fails?
Thoughts??

Which one are you referring to , the option in the Cluster manger or the option in SSMS Agent properties ?

--

SQLBuddy

Veteran Jones SSC Eights! Points: 937 More actions · Answer 3

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?

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 4

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?

We don't have it turned ON. That will cause the SQL Server to failover which is not accepted.

--

SQLBuddy

Perry Whittle SSC Guru Points: 233825 More actions · Answer 5

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" 😉

lptech Hall of Fame Points: 3188 More actions · Answer 6

You should consider whether you want your SQL Server instance failing over without warning, possibly during normal business hours. It might be a better idea to have your monitoring tool report the resource failure, and take action with human intervention.

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 7

lptech (4/1/2014)
You should consider whether you want your SQL Server instance failing over without warning, possibly during normal business hours. It might be a better idea to have your monitoring tool report the resource failure, and take action with human intervention.

Exactly .. This should be the approach ..

--

SQLBuddy