Performance Unleashed: Practical Tuning for Azure SQL and SQL Server
Proposed session for SQLBits 2026TL; DR
Learn how to diagnose and optimize slow SQL Server and Azure SQL workloads. Explore real-world query tuning techniques, Intelligent Query Processing internals, and practical strategies to improve performance and reduce costs across cloud and on-premises environments.
Session Details
Are you looking to accelerate Azure SQL workloads while keeping cloud costs under control — or aiming to achieve the best possible performance from SQL Server on-premises?
This session tackles real-world performance challenges by dissecting slow-running queries to uncover inefficiencies and hidden bottlenecks. Through hands-on examples and proven diagnostic techniques, you will learn how to apply intelligent optimization strategies that deliver measurable improvements in speed and resource utilization.
We take a deep dive into the SQL Server query engine to explore how Intelligent Query Processing (IQP) enhances performance — and where its limitations may affect reliability in production workloads.
Whether you are fine-tuning individual queries or managing databases at scale, this session equips you with practical, actionable insights to make your workloads faster, smarter, and more cost-effective — across both cloud and on-premises environments.
This session tackles real-world performance challenges by dissecting slow-running queries to uncover inefficiencies and hidden bottlenecks. Through hands-on examples and proven diagnostic techniques, you will learn how to apply intelligent optimization strategies that deliver measurable improvements in speed and resource utilization.
We take a deep dive into the SQL Server query engine to explore how Intelligent Query Processing (IQP) enhances performance — and where its limitations may affect reliability in production workloads.
Whether you are fine-tuning individual queries or managing databases at scale, this session equips you with practical, actionable insights to make your workloads faster, smarter, and more cost-effective — across both cloud and on-premises environments.
3 things you'll get out of this session
* Learn proven techniques to diagnose and fix slow-running queries in SQL Server and Azure SQL
* Understand how Intelligent Query Processing works and where its limitations impact real-world workloads
* Apply practical optimization strategies to improve performance and control resource and cloud costs
Speakers
Torsten Strauß's other proposed sessions for 2026
Analyzing Azure SQL Database Workloads with KQL Insights, Patterns, and Performance - 2026
Bicep on Azure – Building Modular and Reusable Infrastructure as Code - 2026
Deep Dive into Memory Grants:Diagnosing and Optimizing Query Performance in Azure SQL and SQL Server - 2026
End-to-End Database DevOps: Building Automated CI/CD Pipelines for Azure SQL - 2026
Hybrid Data in Motion: Near Real-Time Mirroring from SQL Server 2025 into Microsoft Fabric - 2026
Inside Data Compression in SQL Server and Azure SQL: Performance Gains, Trade-offs, and Engine Inter - 2026
Optimized Locking in SQL Server 2025: Internals, Contention, and Concurrency - 2026
Plan Cache Internals in SQL : Parameter Sensitive Plans, Cache Optimization, and Monitoring - 2026
Streamlined Deployments: Robust YAML CI/CD Pipelines for Azure Data Factory - 2026