In the context of a SQL Server Availability Group, what's the best way to monitor a file share witness for accessibility?
I want to make sure the witness can be accessed by the Availability Group replicas, which is something different than just being available. For instance, the account used to run SQL Server needs access rights to the file share.
Edit: I recently noticed some events logged by the cluster worthy of being monitored.
Log Name: System
Source: Microsoft-Windows-FailoverClustering
Date: 6/1/2019 1:23:09 PM
Event ID: 1564
Task Category: File Share Witness Resource
Level: Critical
Keywords:
User: SYSTEM
Computer: node1.contoso.com
Description:
File share witness resource 'File Share Witness' failed to arbitrate for
the file share '\\servername\sharename'. Please ensure that file share
'\\servername\sharename' exists and is accessible by the cluster.
Log Name: System
Source: Microsoft-Windows-FailoverClustering
Date: 6/1/2019 1:23:08 PM
Event ID: 1562
Task Category: File Share Witness Resource
Level: Warning
Keywords:
User: SYSTEM
Computer: node1.contoso.com
Description:
File share witness resource 'File Share Witness' failed a periodic health
check on file share '\\servername\sharename'. Please ensure that file
share '\\servername\sharename' exists and is accessible by the cluster.