爱生活的Iter

导航

SQLServer错误码-DNS 拒绝更新请求,系统不能 注册这些 RR

https://learn.microsoft.com/zh-cn/azure/azure-sql/virtual-machines/windows/hadr-cluster-best-practices?view=azuresql&tabs=windows2012#heartbeat-and-threshold

将群集心跳信号和阈值设置修改为较宽松的设置,默认配置通过查询信息如下:

PS C:\Windows\system32> get-cluster | fl subnet

CrossSubnetDelay : 1000
CrossSubnetThreshold : 20
PlumbAllCrossSubnetRoutes : 0
SameSubnetDelay : 1000
SameSubnetThreshold : 20

PS C:\Windows\system32>

修改为较宽松的设置,方法如下:

(get-cluster).SameSubnetThreshold = 20
(get-cluster).SameSubnetDelay = 2000
(get-cluster). CrossSubnetThreshold = 40
(get-cluster). CrossSubnetDelay = 2000

验证更改:
get-cluster | fl subnet

对于可用性组:
ALTER AVAILABILITY GROUP AG1 SET (HEALTH_CHECK_TIMEOUT = 60000); -- 60000 milliseconds (60 seconds)
ALTER AVAILABILITY GROUP AG1 SET (FAILURE_CONDITION_LEVEL = 2);
对于故障转移群集实例(需要 sysadmin 或 ALTER SETTINGS 权限):
ALTER SERVER CONFIGURATION SET FAILOVER CLUSTER PROPERTY HealthCheckTimeout = 60000; -- 60000 milliseconds (60 seconds)
ALTER SERVER CONFIGURATION SET FAILOVER CLUSTER PROPERTY FailureConditionLevel = 2;

posted on 2026-05-25 19:44  helontian  阅读(20)  评论(0)    收藏  举报