Azure SQL Managed Instance - General Purpose vs. Business Critical Tiers
Вставка
- Опубліковано 9 вер 2024
- This video will provide you with of quick overview of the key differences between the General Purpose and Business Critical Tiers of Azure SQL Managed Instance. After watching you will be better equipped to decide on the correct tier for your workloads.
Great explanation to make decisions
Glad it helped!
The thing is, the replica is still in the same region right? So you're probably better off using GP and creating your own Auto-failover group with a second MI in a second region? That way you've got multi-region HA, which is better than what Business Crit offers.
It just depends on your use case. If your main goal is offloading read-only workloads then using the included replica of the BC tier meets that purpose. The replica is there for high availability purposes and to ensure Microsoft can maintain its SLA’s. But if you are looking for a solution for disaster recover, then, as you stated, auto-failover groups would be the best solution for that use case.
Since the solution is centered around BC and zone redundancy could you use lb as opposed to traffic manage to reduce cost ?
Azure SQL only allows one replica to serve both read and write workloads so load balancing isn’t really a concept here. You can redirect read-only workloads to a secondary replica. Does this answer your question?