| Inhalt: |
Slow queries, blocking, and unpredictable workload spikes are common challenges across SQL Server environments — from on-premises installations to Azure SQL Managed Instance and Azure SQL Database. Yet the true root causes often remain hidden beneath layers of execution plan behavior, indexing issues, and configuration pitfalls. This full-day PreCon equips you with the methodology and hands-on experience to uncover and resolve them systematically.
Led by Torsten, a long-standing Microsoft Data Platform MVP with decades of field experience, the workshop focuses on real-world scenarios rather than artificial demos. Together, we will dissect authentic SQL Server performance issues, analyze them using proven investigative techniques, and apply practical optimization strategies.
You will work with Query Store, execution plans, Extended Events, and core engine features to identify bottlenecks, interpret query behavior, evaluate indexing strategies, and understand critical instance settings. Throughout the day, participants will optimize real workloads, compare solution approaches, and discuss trade-offs and decision paths.
By the end of the workshop, you will take away a repeatable methodology for performance troubleshooting and a toolkit of actionable techniques that improve application responsiveness and resource efficiency. In cloud environments, these improvements can directly translate into measurable cost benefits.
Target Audience:
Database administrators, developers, and IT professionals with foundational Microsoft SQL Server knowledge who want to advance their performance tuning skills.
Prerequisites
• Basic knowledge of T-SQL and SQL Server Management Studio
• Laptop with SQL Server 2022/2025 Developer Edition and the AdventureWorks sample database (recommended) |