Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

Configure FailureConditionLevel Property Settings

Use the FailureConditionLevel property to set the conditions for the AlwaysOn Failover Cluster Instance (FCI) to fail over or restart. Changes to this property are applied immediately without requiring a restart of the Windows Server Failover Cluster (WSFC) service or the FCI resource.

FailureConditionLevel Property Settings

The failure conditions are set on an increasing scale. For levels 1-5, each level includes all the conditions from the previous levels in addition to its own conditions. This means that with each level, there is an increased probability of a failover or restart. For more information, see Determining Failures

Security

Permissions

Requires ALTER SETTINGS and VIEW SERVER STATE permissions

[Top]

To configure FailureConditionLevel settings

  1. Start an elevated Windows PowerShell via Run as Administrator.

  2. Import the FailoverClusters module to enable cluster commandlets.

  3. Use the Get-ClusterResource object to set the FailureConditionLevel property for Failover Cluster Instance.

Example (Powershell)

The following example changes the FailureConditionLevel setting on the “AlwaysOnSrv1” failover cluster instance to failover or restart on critical server errors.

Copy 
Import-Module FailoverClusters

$fci = “AlwaysOnSrv1”
Get-ClusterResource $fci | Set-ClusterParameter FailureConditionLevel 3

[Top]

To configure FailureConditionLevel property settings:

  1. Open the Failover Cluster Manager snap-in.

  2. Expand the Services and Applications and select the FCI.

  3. Right-click the SQL Server resource under Other Resources, and then select Properties from the menu. The SQL Server resource Properties dialog box opens.

  4. Select the Properties tab, enter the desired value for the FaliureConditionLevel property, and then click OK to apply the change.

[Top]

To configure FailureConditionLevel property settings:

Note Note

For an example of this procedure, see Example (Transact-SQL), later in this section.

Using the Data Definition Language (DDL) statement ALTER SERVER CONFIGURATION, you can specify the FailureConditionLevel property value. For syntax details, see Setting failover cluster properties

Example (Transact-SQL)

The following example sets the FailureConditionLevel property to 0 indicating that no failover or restart will be triggered automatically on any failure conditions.

Copy 
ALTER SERVER CONFIGURATION SET FAILOVER CLUSTER PROPERTY FailureConditionLevel = 0;

[Top]

Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ