Ola Hallengren

Ola Hallengren is a Data Platform MVP and the creator of the "SQL Server Maintenance Solution".

Ola Hallengren's Sessions

SQL Server 2022 Performance EnhancementsSQLBits 2024

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 SSQLBits 2018

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 SolutionSQLBits 2014

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 SolutionSQLBits 2011

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.