为什么 SnapCenter 中的 SQL 验证会偶尔导致集群资源出现故障的事件

最后更新
另存为PDF

Views:: 23

Visibility:: Public

Votes:: 0

Category:: snapcenter

Specialty:: snapx

Last Updated:

不可不使用

适用于

适用于 SQL 的 SnapCenter 插件（ SCSQL ）
在其中一个生产集群实例上进行验证

解答

由于在 SnapCenter 验证过程中对 I/O 和磁盘进行高重新扫描、生产 AG 数据库在同一台主机上偶尔会出现资源松动的情况。
虽然资源在一段时间后恢复，但建议对 SnapCenter 验证使用单独的验证实例。

其他信息

系统事件日志中的事件消息可以具有多个事件 ID 和状态：

Cluster resource 'AG_01_Test' of type 'SQL Server Availability Group' in clustered role 'AG_01_Test' failed.

Based on the failure policies for the resource and role, the cluster service may try to bring the resource online on this node or move the group to another node of the cluster and then restart it. Check the resource and group state using Failover Cluster Manager or the Get-ClusterResource Windows PowerShell cmdlet.

集群消息将显示故障转移和恢复的开始，而不会出现以下情况：

DESCRIPTION: The availability group database "highsystem_TEST" is changing roles from "PRIMARY" to "RESOLVING" because the mirroring session or availability group failed over due to role synchronization. This is an informational message only. No user action is required.

DESCRIPTION: The availability group database "highsystem_TEST" is changing roles from "RESOLVING" to "PRIMARY" because the mirroring session or availability group failed over due to role synchronization. This is an informational message only. No user action is required.

这些事件的偶发性说明了一般的处理性能限制