--- title: "Configure HealthCheckTimeout Property Settings | Microsoft Docs" ms.custom: "" ms.date: "06/13/2017" ms.prod: "sql-server-2014" ms.reviewer: "" ms.technology: high-availability ms.topic: conceptual ms.assetid: 3bbeb979-e6fc-4184-ad6e-cca62108de74 author: MashaMSFT ms.author: mathoma manager: craigg --- # 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](/sql/relational-databases/system-stored-procedures/sp-server-diagnostics-transact-sql) 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](#Limits), [Security](#Security) - **To Configure the HeathCheckTimeout setting, using:** [PowerShell](#PowerShellProcedure), [Failover Cluster Manager](#WSFC), [Transact-SQL](#TsqlProcedure) ## 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. ## 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 [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] 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 [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] resource "`SQL Server (INST1)`" to 60000 milliseconds. ```powershell Import-Module FailoverClusters $fci = "SQL Server (INST1)" Get-ClusterResource $fci | Set-ClusterParameter HealthCheckTimeout 60000 ``` ### Related Content (PowerShell) - [Clustering and High-Availability](https://blogs.msdn.com/b/clustering/archive/2009/05/23/9636665.aspx) (Failover Clustering and Network Load Balancing Team Blog) - [Getting Started with Windows PowerShell on a Failover Cluster](https://technet.microsoft.com/library/ee619762\(WS.10\).aspx) - [Cluster resource commands and equivalent Windows PowerShell cmdlets](https://msdn.microsoft.com/library/ee619744.aspx#BKMK_resource) ## 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](/sql/t-sql/statements/alter-server-configuration-transact-sql)[!INCLUDE[tsql](../../../includes/tsql-md.md)] statement, you can specify the HealthCheckTimeOut property value. ### Example (Transact-SQL) The following example sets the HealthCheckTimeout option to 15,000 milliseconds (15 seconds). ```sql ALTER SERVER CONFIGURATION SET FAILOVER CLUSTER PROPERTY HealthCheckTimeout = 15000; ``` ## See Also [Failover Policy for Failover Cluster Instances](failover-policy-for-failover-cluster-instances.md)