An introduction to Extended Events
summary
Intro to on‑prem SQL Server Extended Events showing concrete setup in SSMS, how to script sessions, and how to read .xel output into a temp table for analysis. Demonstrates server-side capture (system_health always on), causality tracking with measurable overhead, and practical events: blocked process reports (seen twice during demo) and an implicit‑conversion anti‑pattern. Notes there are 2000+ events, use of histograms to count procedure calls, and writing sessions to write to .xel files works reliably.
AI-written summary · about
chapters (23)
- 0:00Introduction
- 1:45What are Extended Events
- 3:15Why replace SQL Profiler
- 5:23Key advantages
- 8:37Setting up an Extended Events session
- 12:03Causality tracking
- 13:35Events and fields
- 15:43Actions and global fields
- 17:38Filtering and optimization
- 21:09Storing captured data
- 23:57Live vs historical data
- 26:36Filtering and grouping
- 28:25Advanced analysis
- 29:29Limitations and best practices
- 31:21Save display settings
- 32:06Script sessions
- 34:02XML output in older versions
- 37:24Scripting basics
- 38:07Detect blocked processes
- 42:15Implicit conversion anti-patterns
- 45:06Deadlock detection
- 47:33Histograms for performance
- 49:44Summary
related talks
51mAn introduction to Extended Events- 51mAn introduction to Extended Events
48mSQL Server 2022 hidden gems
01h 02mUnlocking the Full Potential: The Harmonious Dance of EF Core and SQL Server
50mDebugging SQL Server
01h 04mFrom CRUD to Event Sourcing
49mHidden Gems in SQL Server 2022 Database Engine
18mDataEngBytes 2023 - MEL-T3-02 - Alexei de Lauw