Torsten Strauß

Modern SQL Server workloads rely heavily on parallel query execution to achieve scalable performance. However, excessive or inefficient parallelism can lead to increased CPU pressure, longer wait times, and inconsistent query response times.

High-concurrency workloads often expose a critical scalability challenge in SQL Server: page latch contention caused by inserts into clustered indexes with sequential key values. When many sessions attempt to insert into the same “last page” of an index, SQL Server must serialize access using latches—quickly turning into a major bottleneck in high-throughput systems.

SQL Server 2025 introduces significant improvements to the locking engine, including Optimized Locking and the new Lock After Qualification strategy. These enhancements fundamentally change how the engine acquires and holds locks, reducing contention and improving throughput under concurrent workloads.

SQL Performance-Optimierung Langsame Abfragen, blockierte Prozesse oder unerklärliche Lastspitzen – viele SQL Instanzen, ob on-premises oder in der Cloud (Azure SQL Managed Instance oder Azure SQL Database), kämpfen im Alltag mit Performance-Problemen, deren Ursachen oft tief verborgen liegen. Diese zuverlässig zu identifizieren und nachhaltig zu beheben, ist eine Herausforderung, die fundiertes K

Optimizing Azure SQL queries is critical to improving performance and efficiency and reducing operational cloud costs. During the talk, we will dissect slow queries to understand their inefficiencies, employ various diagnostic methods to pinpoint issues, and explore optimization strategies to boost query speed.

This session will guide you through the process of constructing a YAML pipeline within Azure DevOps, tailored for the Azure Data Factory, to facilitate continuous integration and deployment. Initially, the pipeline conducts a validation check on the ARM template before proceeding to generate a build artifact.

In this session, we will look at some examples of slow queries in SQL Server, analyze the root cause, and implement several ways to dramatically increase query speed or workload. We will also discover the limitations of the SQL Server query engine and possible counterproductive effects of intelligent query processing features.

In this session, you will learn how to simplify and standardize Azure SQL database development in Visual Studio SSDT with a custom project template and smart code snippets. The template also includes the Azure CI\CD pipeline templates to automate database build and deployment in Azure DevOps, including unit tests for stored procedures.