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

cluster sql service settings Expand / Collapse
Author
Message
Posted Friday, November 15, 2013 1:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 8:13 PM
Points: 124, Visits: 750
I am getting confused with the following cluster settings. Both are the properties are for the sql server service on cluster. One from the left hand pane and the other from the right hand pane in the cluster console. The options Response to resource failure, failover and the pending timeout are quite misleading. Can someone explain in detail please ?

what happens if I change the pending timeout to 10 secs from 3 minutes. Does it will have impact when bringing the sql service online ? If the service takes more than 10 secs to come online it will restart again and again?

Please find the attachment.


  Post Attachments 
clusters.JPG (20 views, 89.63 KB)
Post #1514846
Posted Saturday, November 16, 2013 6:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 6,365, Visits: 13,695
This link details the policies tab

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1514909
Posted Saturday, November 16, 2013 7:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 12:57 PM
Points: 394, Visits: 1,978
Perry Whittle (11/16/2013)
This link details the policies tab


But what about the other window settings....if the service or application fails more than the maximum in the specified period, it will be left in the failed state. Let us assume my sql server application fails to restart which settings will come into play?
Post #1514920
Posted Saturday, November 16, 2013 8:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 6,365, Visits: 13,695
The failover tab details whether fail back of the resource occurs to a preferred node. It also specifies that if multiple failures occur within a given time period the application should be left offline.

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1514925
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse