Diagnosing query performance problems on Azure SQL Database

Dynamic Management Views, wait stats, execution statistics, and Extended Events are the tools you use on SQL Server on-prem to diagnose long-running queries and server problems. You can use the same tools on Azure SQL. However, there are differences, such as permissions, database-specific views, or XEvents ring buffer target. In this session, we will address specific queries, views, and strategies for query performance tuning on an Azure SQL Database. Let's dive deeper into query optimisation in Azure because, even with automatic tuning, we still need to tune our queries!