Business Intelligence, Data Warehouse and Data Lake

SQTH06 Azure Synapse Serverless Pools: POLARIS Deep Dive

11/17/2022

1:00pm - 2:15pm

Level: Introductory

Bradley Ball

Sr. Azure Engineer for the Azure FastTrack CXP PG

Microsoft

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 architecture for 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 of Serverless SQL Pools
  • About the scale and capacity of Serverless SQL Pools
  • About best practices and performance tuning tips for Serverless SQL Pools