Export (0) Print
Expand All

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.

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.

Arrow icon used with Back to Top link [Top]

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 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)

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.

[Top]

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;

Arrow icon used with Back to Top link[Top]

Community Additions

ADD
Show:
© 2014 Microsoft