Pedro Lopes
aka.ms/sqlserverteam
Pedro Lopes is a Principal Program Manager in the Azure Data SQL Server team, focusing on the Relational Engine for SQL Server and Azure SQL (Query Processor, Query Performance, Programmability).
SQLBits 2020
Query plans: a map to query performance analysis
This session is designed to guide you through what a query plan is and what information it holds to help you diagnose and understand how the code you write is actually executed by the Database Engine.
Stemming from discussions during a PASS Summit focus group and on Twitter, this session was designed to guide you through what a query plan is and what information it holds to help you diagnose and understand how the code you write is actually executed by the Database Engine. This includes tool improvements that ease you into troubleshooting processes: learn how you can leverage faster insights and become the hero of the day!