Muokkaa

Jaa


Configure HealthCheckTimeout Property Settings

Applies to: SQL Server

The HealthCheckTimeout setting is used to specify the length of time, in milliseconds, that the SQL Server resource DLL should wait for information returned by the sp_server_diagnostics stored procedure before reporting the Always On Failover Cluster Instance (FCI) as unresponsive. Changes that are made to the timeout settings are effective immediately and do not require a restart of the SQL Server resource.

Before You Begin

Limitations and Restrictions

The default value for this property is 30,000 milliseconds (30 seconds). The minimum value is 15,000 milliseconds (15 seconds).

Security

Permissions

Requires ALTER SETTINGS and VIEW SERVER STATE permissions.

Using PowerShell

To configure HealthCheckTimeout settings
  1. Start an elevated Windows PowerShell via Run as Administrator.

  2. Import the FailoverClusters module to enable cluster cmdlets.

  3. Use the Get-ClusterResource cmdlet to find the SQL Server resource, then use Set-ClusterParameter cmdlet to set the HealthCheckTimeout property for the failover cluster instance.

Tip

Every time you open a new PowerShell window, you need to import the FailoverClusters module.

Example (PowerShell)

The following example changes the HealthCheckTimeout setting on the SQL Server resource "SQL Server (INST1)" to 60000 milliseconds.

Import-Module FailoverClusters  
  
$fci = "SQL Server (INST1)"  
Get-ClusterResource $fci | Set-ClusterParameter HealthCheckTimeout 60000  
  

Using the Failover Cluster Manager Snap-in

To configure HealthCheckTimeout setting

  1. Open the Failover Cluster Manager snap-in.

  2. Expand Services and Applications and select the FCI.

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

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

Using Transact-SQL

Using the ALTER SERVER CONFIGURATIONTransact-SQL statement, you can specify the HealthCheckTimeOut property value.

Example (Transact-SQL)

The following example sets the HealthCheckTimeout option to 15,000 milliseconds (15 seconds).

ALTER SERVER CONFIGURATION   
SET FAILOVER CLUSTER PROPERTY HealthCheckTimeout = 15000;  

See Also

Failover Policy for Failover Cluster Instances