SQLServer错误码-DNS 拒绝更新请求,系统不能 注册这些 RR
将群集心跳信号和阈值设置修改为较宽松的设置,默认配置通过查询信息如下:
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;
浙公网安备 33010602011771号