SQLBits 2024
An introduction to Extended Events
Introduction to extended events. Learn how to setup and use them.
Are you ready to dive into the awesome world of MSSQL Extended Events! In this presentation, we'll explore this great feature in Microsoft SQL Server that helps you monitor and troubleshoot database performance.
We'll start by understanding what Extended Events are and when they come to the rescue. You'll learn how to set them up step-by-step, customizing them to capture the data you need and show you how to look into the results.
But wait, there's more! We'll also compare Extended Events with the traditional SQL Server Profiler, so you'll know which one to pick for different situations. Plus, we'll share some nifty scripts to start with them right away.
We'll start by understanding what Extended Events are and when they come to the rescue. You'll learn how to set them up step-by-step, customizing them to capture the data you need and show you how to look into the results.
But wait, there's more! We'll also compare Extended Events with the traditional SQL Server Profiler, so you'll know which one to pick for different situations. Plus, we'll share some nifty scripts to start with them right away.
Speakers
Peter Kruis's other proposed sessions for 2026
From GUI to Scripting: PowerShell for the DBA - 2026
Query Store Basics: A DBA’s Best Friend - 2026
Waitstats for the accidental DBA - 2026
From Disarray to Hooray: SQL Server Functions That Simplify T-SQL - 2026
Two Developers, One Mission: Make a Test Database That Doesn’t Suck - 2026