22-25 April 2026 
Query Tuning Telemetry for the Advanced SQL Developer - Part 2
50+50 minute session for SQLBits 2026Saturday - 25 Apr 2026 - 10:00 - 10:50 Room 2BTL; DR
Learn the hidden internals of query processing and apply those lessons in your SQL applications, diving deep into the algebrizer, simplifier, and query optimizer.
Session Details
You are a skilled SQL developers who knows how to make your SQL statements scream with speed. But now you want to advance that skill by analyzing instance-wide performance and overall workload analysis. As it turns out, SQL Server includes a variety of Extended Events, DMVs, hidden DBCC commands, Trace Flags, and other telemetry to help us. Few people know these secrets. We will examine this seldom used instrumentation through a variety of everyday queries to reveal their overall resource consumption and internal behavior. Lots of examples and demos!
3 things you'll get out of this session
Learn advanced and undocumented methods to see the steps of parsing, binding, algebrizing, simplifing, and query optimization.
Explore the SQL Server internal memo structure to see how SQL Server uses the heuristics of the algebrizer and query optimizer.
Walk through a variety of SQL queries whose behavior can be greatly improved when you apply what you’ve learned about the algebrizer and query optimizer.
Explore the SQL Server internal memo structure to see how SQL Server uses the heuristics of the algebrizer and query optimizer.
Walk through a variety of SQL queries whose behavior can be greatly improved when you apply what you’ve learned about the algebrizer and query optimizer.
Speakers
Kevin Kline's other proposed sessions for 2026
Query Tuning Internals for the Advanced SQL Developer - Part 1 - 2026
Stop Firefighting! How to Beat the DBA Burnout Crisis - 2026
Kevin Kline's previous sessions
How to Conduct a Transact-SQL Code Review
Learn a collection of important best practice for Transact-SQL code and how to integrate them into your code acceptance testing for better performance and efficiency.
Shift-Left: A DevOps and Database Story
Database code often works well in a test environment, but end up causing significant performance issues when rolled out to production. In turn, these performance issues lead to lost productivity, excess resource consumption, and lost time spent troubleshooting the issue. But what if we could catch those issues during development? Join Kevin Kline to learn how SolarWind's SQL Sentry can shift performance tuning left to the dev cycle so those issues never occur on production systems in the first place.
SQL Horror Stories
Join Kevin Kline as he takes you on a guided tour of some of the worst and most horrible SQL coding experiences. Some were intention and some were accidental. But all of them will make you wince and laugh! Learn new SQL coding tips and tricks from these cautionary tales.