1

I have a azure sql database in North Europe Region. It is almost 5 MB and it has Basic Pricing Tier. That database is not in Azure VM. I am using PaaS environment. I configured Geo-Replication between North Europe and West Europe. When I tried to failover from West Europe to North Europe, it took 15 minutes. It is unacceptable, 15 minutes for 5 MB. Do you have any idea to reduce failover time?

Thank you

  • Azure SQL does not contain much in the way of tuning failover. At most you could open a ticket up with Azure support to see what is going on. – Shawn Melton Mar 10 '17 at 14:11
  • Did you create a Azure Fail Over Group for Azure SQL Paas servers? or did you activated Geo-replication feature for individual DBs? – hiFI Jul 18 at 10:07
-1

As Igor Pagliai(MSFT) Blog Here of July 3, 2014 has as very well mention about Deep Dive: SQL Server AlwaysOn Availability Groups and Cross-Region Virtual Networks in Azure.

  1. SQL Server AlwaysOn Availability Groups Supported between Microsoft Azure Regions Here

  2. VNet-to-VNet: Connecting Virtual Networks in Azure across Different Regions Here

  3. Configure AlwaysOn Availability Groups in Azure VM (GUI) Here

  4. Configure an ILB listener for AlwaysOn Availability Groups in Azure Here

As per Igor Pagliai , Azure Virtual Network Bandwidth and Latency is main factor in failover scenario.

This is always my primary concern, even on-premise, When I have to build a multi-site AlwaysOn consideration: the connectivity between different datacenters will provide enough network bandwidth and low latency? Remember that we are in Azure and the connectivity between datacenters is provided by connecting two (at least) Virtual Networks using a VPN tunnel that comes with capacity limits, then let me recap some basic considerations:

  • Today, for each Virtual Network, you can have only one VPN Gateway;

  • Each VPN Gateway is able to provide, at the very maximum, a
    theoretical limit of 100Mbits/sec;

  • If you connect a VPN Gateway to multiple Virtual Networks, including on-premise local networks, each channel will share the same theoretical bandwidth limit of 100Mbits/sec;
  • VPN Gateway is backed up by two “hidden” Azure VMs of a certain size in active-passive configuration, able to provide 99,90%
    availability SLA:

Cloud Services, Virtual Machines and Virtual Network SLA Here

ExpressRoute or Virtual Network VPN – What’s right for me? Here

NOTE: In this blog post, I will not cover ExpressRoute, I didn’t test for AlwaysOn AG scenarios.

  • Thank you, I will read that references, but my database is not in Azure VM. I am using PaaS environment. Is that bad practise for geo-replication? – Banu Akkus Mar 2 '17 at 13:38
  • None of this applies to the OPs question. – Shawn Melton Mar 6 '17 at 8:32
  • What does OP mean? I did not understand. – Banu Akkus Mar 6 '17 at 14:12
  • 1
    @BanuAkks OP = Original Poster. Your question is around Azure SQL, this answer is dealing with Azure VMs that are running SQL Server...not the same nor is any of the info added relevant to your situation. – Shawn Melton Mar 10 '17 at 14:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.