ITPub博客

首页 > 数据库 > SQL Server > [AlwaysOn] 创建SQL Server高可用性组T-SQL语法:HEALTH_CHECK_TIMEOUT参数

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

原创 SQL Server 作者:cow977 时间:2019-08-13 07:37:23 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-02

  • 博文量
    661
  • 访问量
    722566