question

JohnJY-4666 avatar image
0 Votes"
JohnJY-4666 asked JohnJY-4666 commented

how can you sure WFCS is the cause?

Hi all,


we have SQL AG role set up on Windows 2012R2 up OS. When SQL AG failovered, how can you sure that
WFCS caused and not AG role?

Thank you!

sql-server-generalwindows-server-clustering
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JohnJY-4666,

We have not received a response from you. Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is not, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue.  Your contribution is highly appreciated.

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @JohnJY-4666,

We need to start from SQL server error log and windows cluster log to analysis why SQL AG failover. The log will tell you that SQL or windows cause this issue.

Generate and analyze the CLUSTER.LOG for an Always On availability group

Use the cluster /log /g command at the command prompt. This command generates the cluster logs to the \windows\cluster\reports directory on each WSFC node. or use the Get-ClusterLog PowerShell cmdlet. Refer to MS document Generate and analyze the CLUSTER.LOG for an Always On availability group.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

Hello @JohnJY-4666,

Windows Server Failover Cluster (WSFC) A WSFC is a group of independent servers that work together to increase the availability of applications and services.

An Always On Failover Cluster Instance (FCI) is a SQL Server instance that is installed across nodes in a WFCS. This type of instance depends on resources for storage and virtual network name.

High availability for an Always On solution is accomplished through proactive health monitoring of physical and logical WFCS cluster resources, together with automatic failover onto and re-configuration of redundant hardware. A system administrator can also initiate a manual failover of an availability group or SQL Server instance from one node to another.

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/windows-server-failover-clustering-wsfc-with-sql-server?view=sql-server-ver15



Hope this answers all your queries, if not please do repost back.
If an Answer is helpful, please click "Accept Answer" and upvote it : )

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JohnJY-4666 avatar image
0 Votes"
JohnJY-4666 answered JohnJY-4666 commented

@Cathyji-msft Thank you! sorry to reply you late. checked Windows failover operational logs and AG failed over first. Can we say AG is the cause? also, see heartbeat lost. Thank you for the help!

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JohnJY-4666,

Which reason cause the SQL AG failover? Which resource cause the SQL AG failover?

0 Votes 0 ·

@cathyji-msft, the following events before 1135 event ID (one node is removed from membership)

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

Cluster resource 'AG' in clustered role 'AG' has transitioned from state ProcessingFailure to state WaitingToTerminate. Cluster resource 'AG' is waiting on the following resources: .

Thank you!

0 Votes 0 ·