Why my query is slow and how to fix this

2022

TL; DR

What is the primary root cause of the query slowness? The answer to this question will lead as to the options to tune it. This session will give a straightforward approach to finding the answer and query optimization based on it.

Session Details

Generally, there are only two options for query slowness: either the query itself is slow (high CPU time), or the query is waiting for some resource (high Wait time). All other reasons for query slowness come from these two options. In this session, we will learn how to determine the reason for the long-running query, what the request can wait for, and how to make the query faster.

3 things you'll get out of this session

Denis Reznik's other proposed sessions for 2026

Deadlocks in SQL Server: Understanding and Troubleshooting - 2026

True SQL Server Detective - 2026

Denis Reznik's previous sessions

What SQL Server database can tell us about application issues?

This session will be about database load patterns that show the application design issues and solutions to those issues.

Hidden Gems of SQL Server 2019

SQL Server 2019 is full of new features. Some of them are very interesting and useful, but unfortunately not well-known. So far.

Query Execution: Expectation-Reality

Sometimes this happens. What you expect not always what you received. In this session, we will look at a bunch of such situations.