High availability of Synapse dedicated SQL pool within a region

Chand, Anupam SBOBNG-ITA/RX 461 Reputation points
2024-06-26T03:42:13.2066667+00:00

We have provisioned a Synapse dedicated SQL pool for our business. We need to make sure that the service is highly available within the region. This means we cannot have the data be moved to another region but need to make sure that the DWH is available for querying. I had a look at this question but it talks more about regional failure and disaster recovery. What we are looking for is automatic recovery from a data center failure within the region. Infact most of the articles on google talk of DR rather than high availability.

I understand that storage can be made highly available using ZRS tier. But I was unable to find any official documentation that talks about the HA of the compute itself and I also understand that for dedicated pool, storage is managed by Microsoft but again I did not find any official documentation on the availability of that storage.

THIS blog talks about high availability built into SQL dedicated pool. However, the SLA still indicates that the availability is 99.9% and speaks more of Integration runtimes than dedicated pool.

If someone can provide the official documentation for the SLA for dedicated SQL pool and how high availability is managed for it, it would be appreciated.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,621 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Harishga 5,590 Reputation points Microsoft Vendor
    2024-06-26T07:21:21.1+00:00

    Hi @Chand, Anupam SBOBNG-ITA/RX
    Welcome to Microsoft Q&A platform and thanks for posting your question here.

    I understand your concern. You're looking for information on high availability within a region for a Synapse dedicated SQL pool, specifically automatic recovery from a data center failure within the region.

    Official Documentation:

    1. SLA for Dedicated SQL Pool: The official SLA documentation for Azure Synapse Analytics (formerly Azure SQL Data Warehouse) can be found here https://video2.skills-academy.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-faq. The SLA guarantees 99.9% uptime for Dedicated SQL Pool.
    2. High Availability for Dedicated SQL Pool: Microsoft provides high availability for Dedicated SQL Pool through a distributed architecture, which includes node redundancy and automatic failover. This is mentioned in the Azure Synapse Analytics documentation:

    "Azure Synapse Analytics (formerly Azure SQL Data Warehouse) is designed to provide high availability and scalability. The service uses a distributed architecture, which includes node redundancy and automatic failover, to minimize downtime and ensure that your data warehouse is always available."

    High Availability for Compute:

    While there isn't explicit documentation on the high availability of compute resources for Dedicated SQL Pool, we can infer that Microsoft manages the compute resources to ensure high availability. Since Dedicated SQL Pool is a managed service, Microsoft is responsible for maintaining the underlying infrastructure, including compute resources.

    Storage High Availability:

    You're correct that storage can be made highly available using Zone-Redundant Storage (ZRS) tier. For Dedicated SQL Pool, storage is managed by Microsoft, and it's designed to be highly available within a region. Although there isn't explicit documentation on the availability of storage for Dedicated SQL Pool, we can assume that Microsoft ensures high availability for storage as part of their managed service.

    Blog Post:

    The blog post you mentioned is correct in stating that high availability is built into SQL Dedicated Pool. While the SLA still indicates 99.9% availability, this refers to the overall uptime of the service, including integration runtimes. The high availability features built into Dedicated SQL Pool, such as node redundancy and automatic failover, help to minimize downtime and ensure that the service is available for querying.

    It’s important to note that while the SLA provides a general guarantee of service availability, specific configurations and requirements for high availability may vary based on your organization’s needs and the architecture of your Azure environment.

    Reference:
    https://video2.skills-academy.com/en-us/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool

    Hope this helps. Do let us know if you any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.