Arizona Data Platform Users Group Meeting

Topic: Answering Questions Using Extended Events
Speaker: Grant Fritchey

Abstract:
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.

Agenda
• 5:00-5:30pm: Networking and Food
• 5:30-5:35 pm: Announcements & Intro
• 5:35-6:35pm: Presentation
• 6:35-7:00pm: Q&A, wrap-up

Bio:
Grant Fritchey is a Data Platform MVP and AWS Community Builder with over 30 years’ experience in IT, including time spent in support and development. Grant works with multiple data platforms including SQL Server and PostgreSQL as well as multiple cloud platforms. He has also developed in VB, VB.NET, C#, and Java. Grant writes books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product advocate in January 2011.