How To Use XEvents Profiler (Extended Events vs SQL Profiler)

Опубликовано: 21 Февраль 2025
на канале: The SQL Guy

3,938

In this video we look at how to use XEvents Profiler and why it might be better than SQL Profiler!

Historically we've always used SQL Profiler, but considering that is soon on it's way out (apparently) we are being pushed to use Extended Events so the battle commences - Extended Events vs Profiler!!

But there need not be a debate. Extended Events is a fantastic tool which is more than capable of monitoring live data in a very similar fashion to SQL Profiler. In this video we go through how to use XE to trace data and show which columns are available to us.

I've also covered it's limitations. As always let me know your feedback below

Thanks

Content

00:00 Introduction
00:44 Why XEvent Profiler?
01:44 How to use XEvent Profiler
03:25 Quick Session Standard
04:40 How To Filter
05:40 Duration and Long running queries
07:35 Can we export the data?
08:21 XEvent Profiler vs SQL Profiler