Forum Discussion

afiqazmi31's avatar
afiqazmi31
Copper Contributor
Oct 11, 2023

SQL Server Failover Cluster Resource/Group stop itself due lost connection to storage

I have an environment where we had; MSSQL Cluster Data, Log and Quorom on iSCSI storage (AWS FSx Ontap) Fileshare witness (AWS FSx Windows)   Just out of curiosity, can MSSQL Server Cluster Re...
RodVK's avatar
RodVK
Copper Contributor
Apr 10, 2024

Hi SivertSolem thanks for the reply but we are using Failover cluster instance, and the rhs.exe is bugchecking after storage seems to disappear after a failover. Not using Always on Availability groups. 

SivertSolem's avatar
SivertSolem
Iron Contributor
Apr 10, 2024

RodVK 

Aah, apologies. That should have been given by using iSCSI as quorum.

The health check timeout is still configurable, but in this case in the Failover Cluster Configuration.

https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/configure-healthchecktimeout-property-settings?view=sql-server-ver16


Powershell

Import-Module FailoverClusters  
  
$fci = "SQL Server (INST1)"  
Get-ClusterResource $fci | Set-ClusterParameter HealthCheckTimeout 60000

 T-SQL

ALTER SERVER CONFIGURATION   
SET FAILOVER CLUSTER PROPERTY HealthCheckTimeout = 60000;

 

Resources