Extending Your Use of Extended Events – Erin Stellato
If you have made the leap to using Extended Events, chances are you’re using XE to do the exact same thing you used to do in Trace. Maybe you use it to capture query performance over time, or find queries that exceed a specific duration, I/O, or CPU. Maybe you want to find what login executed a query, or from what workstation or application the query originated. But Extended Events is so much more than a replacement for Trace; it is a whole new way to think about troubleshooting. In this session we will discuss the targets, actions, and predicates available in Extended Events and see how you can leverage them to look at problems in SQL Server in ways that you never could before. We will step through as many demos as possible in the time available so you can see why joining #TeamXE was one of the best decisions you ever made. You’ll walk away with a deeper understanding of Extended Events along with a new methodology for approaching and solving issues in SQL Server.
Watch the session recording from PASS Summit 2020. For updates on the future of PASS, SQLSaturdays and PASS Summit opt in here: http://www.red-gate.com/pass
Take the opportunity to connect and share this video with your friends and family if you find it useful.