Cost of primary region failover vs sending traffic cross region to DB in Secondary

J3 1 Reputation point
2021-06-29T11:30:14.5+00:00

Have an intranet site I'm looking to lockdown to ensure it's only accessible from within our network. This app uses Traffic Manager for geographical failover and uses a failover groups for azure sql db, as well as using app service that queries the web app using Front Door, and have a storage account of course. For one what is the relationship between the sql failover group and Traffic Manager? Since Failover Groups can already have geo redundancy? My experience with using them was having them all effectively in one region across servers but apparently they can also all be 1 server now. I'm guessing you can basically treat a failover group like any other resource in respect to TM, so we have a fail over group on the primary and secondary region?

Also what is the most cost beneficial way for failover? What is the cost comparison of a failover from primary region failover to the secondary vs just sending traffic cross region to the Azure DB to the Secondary. So for instance if the sql db goes down in region 1 are the extra costs in sending the traffic cross regions to the other db failover group cross region worth it or is it better to failover to the secondary region entirely so the traffic doesn't have to go cross region?

Azure SQL Database
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,029 questions
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,139 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,081 Reputation points Microsoft Employee
    2021-07-15T15:29:48.847+00:00

    Hi @J3 Sorry for the delay , in response to the above questions, if we are talking at the database level for FOG, once you do the failover you will be using the same endpoint, the traffic costs arising from Geo-replication between the primary and secondary databases are included in the costs of the online secondary database.
    Please feel free to reach out if you have additional query regarding this.

    Regards,
    Oury