Explain 'Response to resource failure' configuration in SQL Server Clustering?

Question

Dear Folks,

In SQL Server Clustering, Could any please explain these settings properly. Response to resource failure settings (I think it is also called Restart policy configuration, let me know if am wrong.)

1. If resource fails, do not restart
2. if resource fails, attempt restart on current node

a. Period for restart (mm:ss)

b. Maximum restarts in the specified period.

c. Delay between restarts (ss:f)

3. If restart is unsuccessful, failover all resources in this role.
4. If all the restart attempts fail, begin restarting again after the specified period (hh:mm)

I have attached below sql cluster properties screenshot also.

Thanks

Chirag

Answer 1

Hi @Chirag Sachdeva ,

Thank you for reaching out to Microsoft Fabric Community.

The Response to resource failure settings control the cluster’s restart and failover for the SQL Server resource. Below is the recommended configuration for a typical SQL Server failover cluster:

• If resource fails, attempt restart on current node
• Period for restarts: 15:00 (15 minutes)
• Maximum restarts: 3 (allow up to 3 attempts within the 15-minute window)
• Delay between restarts: 5.0 seconds
• If restart is unsuccessful, fail over all resources in this role: checked (so the whole sql role moves to another node if restarts fail)
• If all restart attempts fail, begin restarting again after: optional, set to 01:00 if you want periodic retries or leave unchecked.
• Pending timeout: Increase if sql takes longer to start, like for example 3 minutes or more.

This helps recover from transient failures quickly.

Thanks,

Anjan Kumar Chippa