Revealing Hidden Performance Issues with Extended Events ~ Jeff Iannucci

Part 1 of a 4-part series about:
Hidden Pathways to Achieving Peak SQL Server Performance

Revealing Hidden Performance Issues with Extended Events

Extended Events may be the most underutilized SQL Server tool for query performance tuning. Did you know there are now Extended Events that can tell you about spills to tempdb, aborted queries, and even queries that execute with common antipatterns? It’s true! With newer Extended Events released in SQL Server 2022, you can now diagnose these query problems and more. You can even measure the impact of these Extended Events with other Extended Events. In this demo-filled session you will see how you can create these powerful Extended Events, how to review the collected data to determine which queries you can improve, and even how to rewrite the captured queries for improved performance. You’ll leave this session with a new set of tools to find and fix hidden performance issues in your SQL Server queries.

Session Goals: To walk away with both an understanding of what newer Extended Events are available in SQL Server, as well as how to use them to improve query performance in legacy code.
Session Prerequisites: Basic knowledge of SQL Server Extended Events would be helpful, but not necessary. Knowledge of T-SQL required.