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

SQL Cluster Expand / Collapse
Author
Message
Posted Tuesday, April 1, 2014 5:43 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 14, 2014 12:15 PM
Points: 245, Visits: 348
Should it be setup so that an instance be set to failover if the SQL Server Agent fails?

Thoughts??
Post #1556921
Posted Tuesday, April 1, 2014 9:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:43 AM
Points: 6,641, Visits: 14,226
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"
Post #1557070
Posted Tuesday, April 1, 2014 9:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:08 AM
Points: 1,194, Visits: 2,228
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
Post #1557077
Posted Tuesday, April 1, 2014 11:06 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 14, 2014 12:15 PM
Points: 245, 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?
Post #1557123
Posted Tuesday, April 1, 2014 11:15 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:08 AM
Points: 1,194, Visits: 2,228
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
Post #1557130
Posted Tuesday, April 1, 2014 1:18 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:43 AM
Points: 6,641, Visits: 14,226
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"


  Post Attachments 
res policy.jpg (42 views, 115.44 KB)
Post #1557179
Posted Tuesday, April 1, 2014 1:53 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:16 AM
Points: 235, Visits: 2,252
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.
Post #1557189
Posted Tuesday, April 1, 2014 2:22 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:08 AM
Points: 1,194, Visits: 2,228
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
Post #1557198
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse