Session Details

View all Conference Sessions

Extending Your Use of Extended Events

Erin Stellato
75 minutes
Data Management
DBA, Consultant
Database Administration
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.
Experience with creating and using Event Session to troubleshoot issues in SQL Server