Sure, you can use Extended Events within SQL Server to capture query performance metrics. However, is that all you really want?

For most people, they want to know the answers to questions. Which query is using the most CPU? Why did that statement recompile? Is Query Store having problems on my database? These and many other questions can be easily answered through the use of Extended Events.

This session explores how to use Extended Events to do more than simply capture performance metrics, although we'll do that too. You can learn to put Extended Events to work in your own systems to answer your own questions based on the information provided here. We'll go beyond simply capturing events and talk about how to combine them through Causality Tracking. We'll also consume the data in ways beyond simply capturing to a file, such as through histograms.

You will better be able to put Extended Events to work helping you answer your questions.