 | |
Failover Threshold
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Failover Threshold -
04-04-2005
, 04:03 AM
#2
| |||
| |||
|
|
Hi all I have a SQL Server cluster running active/passive. Over the weekend due to a network problem, both machines lost connectivity on the public network. We had our Failover Threshold set to 10, and period 6 (ie failover at most 10 times in 6 hours). Our cluster attempted to failover 10 times, then stopped trying (which is what is to be expected). We eventually had to manually restart the SQL service once our network issues were fixed. My question is, if we had left things down for 6 hours (ie, the failover period), would it had tried to start failing over again, or would both nodes just have stayed as offline? Thanks all!! Krissi |
#3
| |||
| |||
|
|
It would stay offline, forever. This is an excellent reason for monitoring software  Cheers, Rod MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://www.msmvps.com/clustering - Blog "Krissi" <Krissi (AT) discussions (DOT) microsoft.com> wrote in message news:C7FF93B7-EC62-4B83-979A-175AED2D3C46 (AT) microsoft (DOT) com... Hi all I have a SQL Server cluster running active/passive. Over the weekend due to a network problem, both machines lost connectivity on the public network. We had our Failover Threshold set to 10, and period 6 (ie failover at most 10 times in 6 hours). Our cluster attempted to failover 10 times, then stopped trying (which is what is to be expected). We eventually had to manually restart the SQL service once our network issues were fixed. My question is, if we had left things down for 6 hours (ie, the failover period), would it had tried to start failing over again, or would both nodes just have stayed as offline? Thanks all!! Krissi |
#4
| |||
| |||
|
|
Thanks. So in this case, there is no way for our cluster to automatically come back online right? "Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in message news:utW2HlQOFHA.576 (AT) TK2MSFTNGP15 (DOT) phx.gbl... It would stay offline, forever. This is an excellent reason for monitoring software Cheers, Rod MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://www.msmvps.com/clustering - Blog "Krissi" <Krissi (AT) discussions (DOT) microsoft.com> wrote in message news:C7FF93B7-EC62-4B83-979A-175AED2D3C46 (AT) microsoft (DOT) com... Hi all I have a SQL Server cluster running active/passive. Over the weekend due to a network problem, both machines lost connectivity on the public network. We had our Failover Threshold set to 10, and period 6 (ie failover at most 10 times in 6 hours). Our cluster attempted to failover 10 times, then stopped trying (which is what is to be expected). We eventually had to manually restart the SQL service once our network issues were fixed. My question is, if we had left things down for 6 hours (ie, the failover period), would it had tried to start failing over again, or would both nodes just have stayed as offline? Thanks all!! Krissi |
#5
| |||
| |||
|
|
Monitoring software Cheers, Rod MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://www.msmvps.com/clustering - Blog "Krissi" <krissi (AT) hotmail (DOT) com> wrote in message news:4251d856$1 (AT) quokka (DOT) wn.com.au... Thanks. So in this case, there is no way for our cluster to automatically come back online right? "Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in message news:utW2HlQOFHA.576 (AT) TK2MSFTNGP15 (DOT) phx.gbl... It would stay offline, forever. This is an excellent reason for monitoring software Cheers, Rod MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://www.msmvps.com/clustering - Blog "Krissi" <Krissi (AT) discussions (DOT) microsoft.com> wrote in message news:C7FF93B7-EC62-4B83-979A-175AED2D3C46 (AT) microsoft (DOT) com... Hi all I have a SQL Server cluster running active/passive. Over the weekend due to a network problem, both machines lost connectivity on the public network. We had our Failover Threshold set to 10, and period 6 (ie failover at most 10 times in 6 hours). Our cluster attempted to failover 10 times, then stopped trying (which is what is to be expected). We eventually had to manually restart the SQL service once our network issues were fixed. My question is, if we had left things down for 6 hours (ie, the failover period), would it had tried to start failing over again, or would both nodes just have stayed as offline? Thanks all!! Krissi |
#6
| |||
| |||
|
|
Do you have any suggestions/recommendations on software? "Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in message news:#sFo6iXOFHA.3704 (AT) TK2MSFTNGP12 (DOT) phx.gbl... Monitoring software Cheers, Rod MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://www.msmvps.com/clustering - Blog "Krissi" <krissi (AT) hotmail (DOT) com> wrote in message news:4251d856$1 (AT) quokka (DOT) wn.com.au... Thanks. So in this case, there is no way for our cluster to automatically come back online right? "Rodney R. Fournier [MVP]" <rod (AT) die (DOT) spam.die.nw-america.com> wrote in message news:utW2HlQOFHA.576 (AT) TK2MSFTNGP15 (DOT) phx.gbl... It would stay offline, forever. This is an excellent reason for monitoring software Cheers, Rod MVP - Windows Server - Clustering http://www.nw-america.com - Clustering Website http://www.msmvps.com/clustering - Blog "Krissi" <Krissi (AT) discussions (DOT) microsoft.com> wrote in message news:C7FF93B7-EC62-4B83-979A-175AED2D3C46 (AT) microsoft (DOT) com... Hi all I have a SQL Server cluster running active/passive. Over the weekend due to a network problem, both machines lost connectivity on the public network. We had our Failover Threshold set to 10, and period 6 (ie failover at most 10 times in 6 hours). Our cluster attempted to failover 10 times, then stopped trying (which is what is to be expected). We eventually had to manually restart the SQL service once our network issues were fixed. My question is, if we had left things down for 6 hours (ie, the failover period), would it had tried to start failing over again, or would both nodes just have stayed as offline? Thanks all!! Krissi |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.