Hi Leo Ng Firs in a normal Always On Availability Group configuration, the failover decision is based on the health of the primary replica and the availability of a quorum. If the primary node (SQL01) remains healthy and the File Share Witness (\adServer01\sqlcluster) is accessible, a failover to the secondary node (SQL02) will not be triggered. As long as the primary node and the File Share Witness are available, the system will continue to operate with the primary node. secondly consider adding an extra File Share Witness for fault tolerance, configuring the cluster with Node Majority for distributed voting, exploring Azure's Cloud Witness for a cloud-based option, and ensuring regular monitoring and maintenance. Testing failovers in a controlled environment is crucial to identifying and addressing any potential issues proactively.
https://learn.microsoft.com/en-us/search/?terms=Always%20On%20availability%20groups%20(SQL%20Server) Kindly accept the answer if this helped, thanks much.