An introduction to Extended Events
summary
Introduction to Extended Events with demos in SSMS showing how to create sessions, script them, and read live and historical .xel files; key events used are batch_completed and statement_completed with duration, CPU and text captured, and causality tracking mapping statements to batches; storage choices cover ring buffer vs file and rollover limits; examples include a blocked-process report firing during a live block and detection of an implicit conversion anti-pattern; overhead and 32-bit SSMS limits are measured and shown.
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
50mDebugging SQL Server
01h 04mFrom CRUD to Event Sourcing
01h 02mUnlocking the Full Potential: The Harmonious Dance of EF Core and SQL Server
18mDataEngBytes 2023 - MEL-T3-02 - Alexei de Lauw
44mBenchmarking in the cloud