Have you ever wondered if Extended Events is affecting the performance of your workload? I have written a lot about Extended Events and have been a huge promoter of why you should be using Extended Events instead of SQL Trace for longer than I have worked at SQLskills.com. While Extended Events provides a lot of benefits to data collection with minimal overhead, there are still cases where observation overheads exist when collecting data even with Extended Events.
Measuring “Observer Overhead” of SQL Trace vs. Extended Events – SQLPerformance.com
SQL Server 2022 offers a new feature enhancement to Extended Events