Skip to content

configure-healthchecktimeout-property-settings.md

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 Configure HealthCheckTimeout for availability group
description Configure HealthCheckTimeout for an Always On availability group, which specifies how long the SQL Server resource DLL waits before reporting unresponsiveness.
author MashaMSFT
ms.author mathoma
ms.date 03/09/2017
ms.service sql
ms.subservice failover-cluster-instance
ms.topic 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