Synapse Vs Azure SQL Hyperscale RRS feed

  • Question

  • I'm trying to understand the roadmap for Azure SQL DW Hyperscale now that Microsoft has branded Azure SQL DW as Synapse.

    1. Is Synapse using Hyperscale under the hood?

    2. Whats the recommended Azure SQL DW to use with Synapse? 

    Thursday, May 14, 2020 6:14 PM

All replies

  • Hello,

    1. Is Synapse using Hyperscale under the hood?

    No, Hyperscale database is an Azure SQL Database.

    What is a Hyperscale database?

    A Hyperscale database is an Azure SQL database in the Hyperscale service tier that is backed by the Hyperscale scale-out storage technology. A Hyperscale database supports up to 100 TB of data and provides high throughput and performance, as well as rapid scaling to adapt to the workload requirements. Scaling is transparent to the application – connectivity, query processing, etc. work like any other Azure SQL database.

    What resource types and purchasing models support Hyperscale?

    The Hyperscale service tier is only available for single databases using the vCore-based purchasing model in Azure SQL Database.

    Reference: Azure SQL Database Hyperscale FAQ

    2. What’s the recommended Azure SQL DW to use with Synapse? 

    Azure Synapse Analytics is an evolution of Azure SQL Data Warehouse into an analytics platform, which includes SQL pool as the data warehouse solution. This platform combines data exploration, ingestion, transformation, preparation, and a serving analytics layer.

    What is Azure Synapse Analytics?

    Azure Synapse is an integrated data platform for BI, AI, and continuous intelligence. It connects various analytics runtimes such as SQL and Spark through a single platform that provides a unified way to:

    • Secure your analytics resources, including network, managing single sign-on access to pool, data, and development artifacts.
    • Easily Monitor and quickly optimize, react, and debug events happening in your workspace activities at any layer.
    • Manage your metadata across engines. Create a Spark table and it will be automatically available in your Azure Synapse databases.
    • Interact with the data through a unified user experience. Synapse Studio brings Big Data Developers, Data Engineers, DBAs, Data Analysts, and Data Scientists on to the same platform.

    What are the main components of Azure Synapse Analytics?

    Azure Synapse has the following capabilities:

    • Analytics capabilities are offered through SQL pool or SQL on-demand (preview) (Serverless).
    • Apache Spark pool (preview) with full support for Scala, Python, SparkSQL, and C#
    • Data Flow offering a code-free big data transformation experience
    • Data Integration & Orchestration to integrate your data and operationalize all of your code development
    • Studio to access all of these capabilities through a single Web UI

    Reference: Azure Synapse Analytics (workspace preview) frequently asked questions

    To understand more difference between Azure Synapse (SQL DW) and Azure Synapse Workspaces, kindly go through the Azure Synapse Analytics – Documentation.

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


    Do click on "Mark as Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

    Friday, May 15, 2020 7:04 AM
  • Hello,

    Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same. And, if you have any further query do let us know.

    Tuesday, May 19, 2020 11:20 AM
  • Hello,

    Following up to see if the above suggestion was helpful. And, if you have any further query do let us know

    Wednesday, May 20, 2020 12:47 PM