SQL Server Features Components

SQTH03 Azure Synapse Analytics: POLARIS the Distributed Query Engine Deep Dive


9:30am - 10:45am

Bradley Ball

Sr. Azure Engineer for the Azure FastTrack CXP PG


Josh Luedeman

Principal Engineering Manager


As part of a multi-year project to re-architect the query processing framework in the SQL DW parallel data warehouse services the POLARIS distributed query engine was developed. If you work with Azure Synapse Analytics and analytical workloads then this session is for you. We will review our new architecture for Generation 3 Provisioned Pools and SQL Serverless Pools. We will demonstrate how to resize live workloads, deliver predictable performance at scale, and how to effectively handle unstructured and relational data.

You will learn:

  • About the underlying architecture changes for Generation 3 Provisioned & Serverless Pools
  • Demonstrate using Serverless Pools to read unstructured data
  • Demonstrate auto scale up and scale out multi-clusters