Monitor CSV and stop the group if CSV failures happen.

DSC
1

In WFC a shared disk device has a dependency on a cluster resource like SQL Server. With the introduction of CSV (Cluster Shared Volumes) this dependency isn’t there any longer because we assume that a CSV is always there. That’s right (sometimes), but if a SAN failure happens, the CSV or several volumes presenting the CSV will be gone and SQL Server will start again. Ths brings SQL Server in an unpredictable situation and happened.

So we like to have a PowerShell-Script (running on every node on the cluster) monitoring the CSV and stopping the group hosting the SQL resources if CSV failures happen.

2

This seems like a good starting place:
https://gallery.technet.microsoft.com/scriptcenter/Monitor-Cluster-Shared-21de7554

3

In WFC a shared disk device has a dependency on a cluster resource like SQL Server. With the introduction of CSV (Cluster Shared Volumes) this dependency isn’t there any longer because we assume that a CSV is always there. That’s right (sometimes), but if a SAN failure happens, the CSV or several volumes presenting the CSV will be gone and SQL Server will start again. Ths brings SQL Server in an unpredictable situation and happened.

So we like to have a PowerShell-Script (running on every node on the cluster) monitoring the CSV and stopping the group hosting the SQL resources if CSV failures happen.

Please share the script if you have, It’s urgent.