22-25 April 2026 
SQLBits 2018
Performance Monitoring Using Extended Events, DMVs & Query S
Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools. In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems.
Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools that gives you a lot of data when analyzing performance problems. All this is great news for database administrators. The challenge is which tool to use for which problems and how to combine the data.
Imagine a scenario where you are getting timeouts from a business critical application, the users are complaining, and you are trying to understand what is happening. You have data from XEvents, you are looking in the execution related DMVs, and now you are trying to find the query in Query Store. How do you put it all together?
In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems. We will look at common real-world problems, do the troubleshooting step by step, and visualize the data using PowerBI.
Imagine a scenario where you are getting timeouts from a business critical application, the users are complaining, and you are trying to understand what is happening. You have data from XEvents, you are looking in the execution related DMVs, and now you are trying to find the query in Query Store. How do you put it all together?
In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems. We will look at common real-world problems, do the troubleshooting step by step, and visualize the data using PowerBI.
Speakers
Ola Hallengren's other proposed sessions for 2026
The Latest Performance Improvements in Azure SQL Database, Managed Instance, and SQL Server 2025 - 2026
Ola Hallengren's previous sessions
SQL Server 2022 Performance Enhancements
In this session we are going to look at the performance enhancements in SQL Server 2022. We will cover the most important enhancements in the optimizer (intelligent query processing), storage engine, Accelerated Database Recovery, availability groups, Query Store, stack dumps and some more.
Which problems are the features solving? How are they doing it?
I will share some real-world experiences of the features, from running SQL Server 2022 on mission-critical databases.
Performance Monitoring Using Extended Events, DMVs & Query S
Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools. In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems.
Inside Ola Hallengrens Maintenance Solution
In this session I will talk about backup, integrity check, and index and statistics maintenance, and how you can use my maintenance solution (http://ola.hallengren.com) in an enterprise environment.
Inside Ola Hallengrens Maintenance Solution
How do you do database maintenance in an enterprise environment? In this session I will go through how you can do backup, integrity check, index and statistics maintenance using Ola Hallengren's Maintenance Solution.