SQL Server Performance Tuning and Optimization

SQT09 Let's Make Azure SQL FASTER

11/14/2023

4:15pm - 5:30pm

Level: Introductory to Intermediate

Bradley Ball

Sr. Azure Engineer for the Azure FastTrack CXP PG

Microsoft

Azure SQL Database, Azure SQL Managed Instance, SQL Server 2014 to 2022 on an Azure VM. There are tips and tricks to make each of them run faster. We will cover tips specific to each service and talk about how they relate to the SQL Server Engine, which is the same in all of them! Leave this session with a better understanding of which version to pick, when to pick it, and what to do to make it run faster.

You will learn:

  • How Azure SQL Database Tiers affect CPU, Memory, IOPs, & Networking performance
  • How Azure SQL Managed Instances Tiers affect CPU, Memory, IOPs, & Networking
  • How SQL Server on Azure Virtual Machines Tiers & versions affect CPU, Memory, IOPs, & Networking