Business Intelligence, Data Warehouse and Data Lake, Fast Focus

SQT03 Fast Focus: Azure Synapse: Top Five Performance Killers

11/14/2023

1:30pm - 1:50pm

Level: Introductory

Amy Herold

Sr. Cloud Solution Architect-Engineering

Microsoft

In Azure Synapse dedicated SQL pools our queries should run with lightning speed - but what do you do when they are not performing as expected? In this session we'll cover the top five reasons you might see lackluster performance in your queries, and how you can begin to tackle those issues.

You will learn:

  • The importance of updating statistics and clustered columnstore indexes
  • The distribution of data on disk vs. distribution of data at query time
  • Common query design issues that can contribute to performance issues, including (but not limited to) overly complex queries, repetition of work, and subqueries