[AlwaysOn] 创建SQL Server高可用性组T-SQL语法：HEALTH_CHECK_TIMEOUT参数

HEALTH_CHECK_TIMEOUT = milliseconds

指定在WSFC群集假定服务器实例运行缓慢或挂起之前，sp_server_diagnostics系统存储过程返回服务器运行状况信息的等待时间(毫秒)。Specifies the wait time (in milliseconds) for the sp_server_diagnostics system stored procedure to return server-health information before the WSFC cluster assumes that the server instance is slow or hung. 健康检查超时(HEALTH_CHECK_TIMEOUT)在组级别设置，但仅与配置为自动故障转移的同步提交可用性模式(AVAILABILITY_MODE = SYNCHRONOUS_COMMIT)的可用性副本相关。HEALTH_CHECK_TIMEOUT is set at the group level but is relevant only on availability replicas that are configured for synchronous-commit availability mode with automatic failover (AVAILABILITY_MODE = SYNCHRONOUS_COMMIT). 此外，只有将主副本和辅助副本都配置为自动故障转移模式(FAILOVER_MODE = AUTOMATIC)，并且辅助副本当前与主副本同步时，运行状况检查超时才能触发自动故障转移。Furthermore, a health-check timeout can trigger an automatic failover only if both the primary and secondary replicas are configured for automatic failover mode (FAILOVER_MODE = AUTOMATIC) and the secondary replica is currently synchronized with the primary replica.

默认的健康检查超时(HEALTH_CHECK_TIMEOUT)值为30000毫秒(30秒)。The default HEALTH_CHECK_TIMEOUT value is 30000 milliseconds (30 seconds). 最小值为15000毫秒(15秒)，最大值为4294967295毫秒。The minimum value is 15000 milliseconds (15 seconds), and the maximum value is 4294967295 milliseconds.

重要 Important

sp_server_diagnostics 不在数据库级别执行运行状况检查。 sp_server_diagnostics does not perform health checks at the database level.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81227/viewspace-2653477/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81227/viewspace-2653477/