This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
After performing Windows patching, we are seeing the following error: "Clustered role 'sqlag' has exceeded its failover threshold. It has exhausted the configured number of failover attempts within the failover period of time allotted to it and will be left in a failed state." We have exceeded the threshold values, yet the same error persists. We have not found any additional errors except for Event ID 1254: "Clustered role 'SQL Server (XXXXXX)' has exceeded its failover threshold. It has exhausted the configured number of failover attempts within the failover period of time allotted to it and will be left in a failed state."
Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi @Vanitha Dodla (MINDTREE LIMITED),
Go to your Roles, click on AG and on the bottom, you have resources - click on it. Then open properties of other resource - Your AG and go to Policies and play with those values.
change the Maximum failures in a specified period to a larger number.
For more information, you can check SQL Server error log and the cluster log to identify what happened. Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
