22-25 April 2026 
Why my query is slow and how to fix this
2022TL; 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.