Configure HealthCheckTimeout Property Settings
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 AlwaysOn 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
Before You Begin
Limitations and Restrictions
The default value for this property is 60,000 milliseconds (60 seconds). The minimum value is 15,000 milliseconds (15 seconds).
Security
Permissions
Requires ALTER SETTINGS and VIEW SERVER STATE permissions.
[Top]
Using PowerShell
To configure HealthCheckTimeout settings
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 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
Related Content (PowerShell)
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
[Top]
Using the Failover Cluster Manager Snap-in
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.
[Top]
Using Transact-SQL
Using the ALTER SERVER CONFIGURATION Transact-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;
[Top]