SQL Server Extended Events has a highly scalable and highly configurable architecture that allows users to collect as much or as little information as is necessary to troubleshoot or identify a performance problem.
Useful links:
- Extended Events Microsoft Docs
- Creating a SQL Server audit using SQL Server Extended Events and Triggers (by Ahmad Yaseen)
- How to automate SQL Server deadlock collection process using Extended Events and SQL Server Agent (by Jefferson Elias)
- Find Your Dark Queries
- Finding Blocked Processes and Deadlocks using SQL Server Extended Events
- What event information can I get by default from SQL Server?
- Understanding the sql_text Action in Extended Events
- Extended Events Series (1 of 31) – An Overview of Extended Events
- Deep dive into the Extended Events Histogram target
- Paul S. Randal articles about extended events
- Jonathan Kehayias articles about extended events
- Jonathan Kehayias extended 31 day series
- Erin Stellato articles about extended events
- Stairway to SQL Server Extended Events (by Erin Stellato)
- Measuring “Observer Overhead” of SQL Trace vs. Extended Events (by Jonathan Kehayias)
- An Identity Crisis: Is it Profiler or is it Extended Events? (by Jason Brimhall)
Courses:
- Learning Extended Events in 60 Days (by Jason Brimhall)
- SQL Server: Introduction to Extended Events (by Jonathan Kehayias)
- SQL Server: Advanced Extended Events (by Jonathan Kehayias)
- SQL Server: Replacing Profiler with Extended Events (by Erin Stellato)