Share via

Handling Failover Policy Alerts Due to Mismatched SLOs in Azure SQL

GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
2024-07-25T17:53:29.4166667+00:00

What should I do if I am getting failover alerts on my Azure SQL failover group that contains at least one database with mismatched Service Level Objectives (SLOs)?

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,597 Reputation points Microsoft Employee Moderator
    2024-07-25T17:54:19.3166667+00:00

    Greetings!

    If you are receiving failover alerts on your Azure SQL failover group due to mismatched Service Level Objectives (SLOs), this indicates that the primary and secondary databases in the failover group do not have the same service tier or compute tier/size. Azure SQL will eventually update the failover policy from Microsoft Managed to Customer Managed if the SLOs are mismatched.

     

    For more detailed information, you can refer to the official Azure documentation: Failover groups overview & best practices - Azure SQL Database

     

    Hope this helps. If you have any follow-up questions, please let me know. I would be happy to help.

     

    Please do not forget to "up-vote" wherever the information provided helps you, as this can be beneficial to other community members.

    Regards

    Geetha

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.