Arizona Data Platform Users Group Meeting

Topic: Making the Most of Query Store in the Real World

Speaker: Jeff Iannucci

Abstract:
Query Store has been described as SQL Server’s “black box”, recording all sorts of information about executed queries. But is that what it is to you – a black box? In this session, you will learn simple yet effective ways to use this incredible feature for troubleshooting real-world query issues like deadlocks, parameter sniffing, and excessive resource consumption. We will focus on leveraging the provided reports as well as querying the underlying tables with your own scripts or free, community-supported tools. You will leave with a greater understanding of the practical ways you can leverage Query Store to resolve query issues in your databases.

Agenda
• 5:15-5:30pm: Sign Drivetime Covid waiver, get some food, and network
• 5:30-5:35 pm: Announcements & Intro
• 5:35-6:35pm: Presentation
• 6:35-7:00pm: Q&A, wrap-up

Bio

Drivetime in Tempe!
1720 W Rio Salado Pkwy, Tempe, AZ 85281
Parking is free!
Microsoft Teams meeting Link included as this is a Hybrid event