There are a myriad of options for running SQL these days with SQL DB, SQL on VMs in Azure, Azure SQL Managed Instance, and SQL Server on-premises the most common. Fundamentally, troubleshooting query performance is the same, but there are nuances to be aware of that are specific to your flavor of SQL.
If you're new to SQL or simply want to learn more about troubleshooting performance whether you're a developer, DBA, or general admin, this session is for you.
Using real-world scenarios, we'll discuss when you should use Query Store, Extended Events, or other DMVs and scripts to troubleshoot issues with query performance. Not only will you understand where to start with an issue, with each method we'll take note of differences in SQL versions. Come to this session prepared to learn and ask questions, and walk away with scripts and references that are the foundations of any good troubleshooting toolkit.
