SQLBits 2018

Why is SQL Server waiting for what?

You are wondering why SQL Server is waiting endless for a request and you don't know what is going on inside? A look behind the curtain with comon scenarios will help you to understand and solve long waits in SQL Server.

SQL Server is a high frequently used piece of software which need to serve single requests
and/or hundreds of thousands of requests in a minute. Within these different
kinds of workloads Microsoft SQL Server has to handle the concurrency of tasks
in a fashion manner. This demo driven session shows different scenarios where
Microsoft SQL Server has to wait and manage hundreds of tasks. See, analyze and
solve different wait stats due to their performance impact:

- CXPACKET: when a query goes parallel
- ASYNC_IO_COMPLETION: speed up IO operations (Growth / Backup / Restore)
- ASYNC_NETWORK_IO: What happens if your application refuses data?
- THREADPOOL starvation: crush of requests for Microsoft SQL Server
- PAGELATCH_xx: How Microsoft SQL Server protects data?

Uwe Ricken's other proposed sessions for 2026

Demystifying Clustered Indexes in SQL Server - 2026

Evolution of User-Defined Functions in Microsoft SQL Server - 2026

How to properly handle LOB data in SQL Server - 2026

Leveraging JSON in Microsoft SQL Server - 2026

Uwe Ricken's previous sessions

Security techniques for cross database access

Security is given too little attention in the database environment and many times more rights are given than are necessary. Especially with CROSS DATABASE access, the goal is often overshot. Learn how to securely access data in other databases without breaking the bank.

Partitioning for Beginners

Introduction of areas for partitioning for Beginners

Why is SQL Server waiting for what?

You are wondering why SQL Server is waiting endless for a request and you don't know what is going on inside? A look behind the curtain with comon scenarios will help you to understand and solve long waits in SQL Server.

Inside statistics-a guessing game

A query was running fast yesterday and today it suffers from performance problems. What will you do? - restart the server (did work) - drop the procedure cache (read in a blog article) - get a coffee and pass in review this session about statistics

Deep dive into the secrets of Temporal Tables

Temporal Tables as a new technology in Microsoft SQL Server makes the implementation and management of data histories so easy. In this session, discover ALL the secrets of System Versioned Temporal Tables.

Daily problems with indexing and its-possible-solution

This session will demonstrate query performance issues a dba is confronted with every day. The demos will handle these scenarios and it's solution