DBA Basics: Getting Started with Performance Tuning

2022

TL; DR

Have you ever found yourself in need of making queries go faster but didn't know where to begin? You will learn how to find your top offenders, basics of execution plans and an index tuning framework to help you start as a performance tuner.

Session Details

Have you ever found yourself in need of making queries go faster but didn't know where to begin? In this session, you will learn multiple ways to find your top offending statements. You will learn three key tips to help you understand execution plans. Finally, you will learn a framework to help you create indexes to help performance.

3 things you'll get out of this session

Speaker

John Sterrett's previous sessions

Three things to know before going Independent - 2023

Building your first Index - 2022

DBA Basics: Getting Started with Performance Tuning - 2022

Getting Started: Introduction to Azure SQL Database - 2022

Make Your SQL Server Queries Go Faster - 2022

Replay in the Cloud: Introduction to the SQL Server Database Experimentation Assistant - 2022