SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Cluster


SQL Cluster

Author
Message
Veteran Jones
Veteran Jones
SSC Veteran
SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)

Group: General Forum Members
Points: 261 Visits: 348
Should it be setup so that an instance be set to failover if the SQL Server Agent fails?

Thoughts??
Perry Whittle
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19722 Visits: 17239
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
sqlbuddy123
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2334 Visits: 2243
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
Veteran Jones
SSC Veteran
SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)

Group: General Forum Members
Points: 261 Visits: 348
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
sqlbuddy123
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2334 Visits: 2243
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
Perry Whittle
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19722 Visits: 17239
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" ;-)
Attachments
res policy.jpg (46 views, 115.00 KB)
lptech
lptech
SSC-Addicted
SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)SSC-Addicted (464 reputation)

Group: General Forum Members
Points: 464 Visits: 3355
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
sqlbuddy123
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2334 Visits: 2243
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search