| title | Configure HealthCheckTimeout Property Settings | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 2017-03-09 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | 3bbeb979-e6fc-4184-ad6e-cca62108de74 | |
| caps.latest.revision | 31 | |
| ms.author | mikeray | |
| manager | jhubbard |
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, Security
-
To Configure the HeathCheckTimeout setting, using: PowerShell, Failover Cluster Manager, Transact-SQL
The default value for this property is 30,000 milliseconds (30 seconds). The minimum value is 15,000 milliseconds (15 seconds).
Requires ALTER SETTINGS and VIEW SERVER STATE permissions.
-
Start an elevated Windows PowerShell via Run as Administrator.
-
Import the FailoverClusters module to enable cluster cmdlets.
-
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.
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
-
Clustering and High-Availability (Failover Clustering and Network Load Balancing Team Blog)
-
Getting Started with Windows PowerShell on a Failover Cluster
-
Cluster resource commands and equivalent Windows PowerShell cmdlets
To configure HealthCheckTimeout setting
-
Open the Failover Cluster Manager snap-in.
-
Expand Services and Applications and select the FCI.
-
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.
-
Select the Properties tab, enter the desired value for the HealthCheckTimeout property, and then click OK to apply the change.
Using the ALTER SERVER CONFIGURATION[!INCLUDEtsql] statement, you can specify the HealthCheckTimeOut property value.
The following example sets the HealthCheckTimeout option to 15,000 milliseconds (15 seconds).
ALTER SERVER CONFIGURATION
SET FAILOVER CLUSTER PROPERTY HealthCheckTimeout = 15000;