Query Store In-Depth

In this session we will look at how you can use Query Store for troubleshooting performance problems, and PowerBI and PowerPivot for analyzing and visualizing the data

Query Store has become one of the most important tools for troubleshooting performance problems. In this session I will share my experiences about how Query Store is working in different scenarios. We will also look at some real-world cases. Finally, we will look at how you can use PowerBI and PowerPivot to analyze and visualize the data from Query Store.

Speaker

Ola Hallengren is a DBA and database developer living in Sweden. Currently he's a Principal Database Architect for an investment bank. Ola is the author of the popular maintenance solution at https://ola.hallengren.com and a Microsoft MVP.

Ola Hallengren's Sessions

SQL Server 2022 Performance Enhancements

Ask the Expert - Group A (Thurs 13:40 to 14:00)

Query Store In-Depth

Performance Monitoring Using Extended Events, DMVs & Query S

Building a Performance Monitoring System Using XEvents

Inside Ola Hallengrens Maintenance Solution