An introduction to Extended Events
summary
Shows how to set up Extended Events for on‑prem SQL Server: creating sessions in SSMS, choosing events, adding causality tracking, and writing to an .xel file versus ring buffer. Demonstrates locating slow queries and implicit conversions using the blocked process report and the 2022 query anti‑pattern events, building histograms of stored‑procedure usage, scripting sessions to deploy on other servers, exporting display settings, and the expected overhead and file rollover settings.
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
18mDataEngBytes 2023 - MEL-T3-02 - Alexei de Lauw
01h 04mFrom CRUD to Event Sourcing
52mDetecting Malicious Activity: Unveiling the Secrets of MS-SQL Logging