Skip to content

Latest commit

 

History

History
85 lines (55 loc) · 4.41 KB

configure-healthchecktimeout-property-settings.md

File metadata and controls

85 lines (55 loc) · 4.41 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic
Configure HealthCheckTimeout for availability group
Configure HealthCheckTimeout for an Always On availability group, which specifies how long the SQL Server resource DLL waits before reporting unresponsiveness.
MashaMSFT
mathoma
03/09/2017
sql
failover-cluster-instance
how-to

Configure HealthCheckTimeout Property Settings

[!INCLUDE 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 [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] resource "SQL Server (INST1)" to 60000 milliseconds.

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

Related Content (PowerShell)

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 CONFIGURATION[!INCLUDEtsql] 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