Over the next couple of months, I’ll be putting on a number of different sessions teaching about the tools supplied by Microsoft, for free, that can help you when tuning your queries. One of the most important of these tools is Extended Events.
A couple of my sessions in the Redgate Community Circle livestream “Built-in Tools Make Query Performance Tuning Easier” will be on Extended Events. My livestreaming starts tomorrow, April 21, at 2pm Eastern. It will be recorded and made available for free. Follow the link for all the details, or, just subscribe to Redgate’s YouTube account.
I’m also going to be hosting a fundamentals introduction to Extended Events, “The Easy Way to Extended Events.” Heck, I’m even going to be hosting a session showing how to use Extended Events with Redgate SQL Monitor (not a part of the Community Circle content, so I won’t share the link here. You can track it down).
However, it’s really important to me that you understand just how powerful and amazing a tool Extended Events is. Further, that you have some resources to get going on this. So, I reached out to a bunch of friends and acquaintances and just some rando’s on the internet to compile a list of the very best of their Extended Events posts.
I’ll be sharing and promoting these links in all my upcoming sessions. They’re in the published slide decks. However, I also want to share them here.
Best Extended Events Posts
These are in the order in which I received them, so no preferences of any kind are being shown. I’d recommend looking through each and every one of them. Not only do they show the incredible power and versatility of Extended Events, but they show some really useful stuff to make your jobs easier.
Erik Darling: https://t.co/gZeXA8DjTw
William Durkin: https://t.co/U1z9Huol0y
Jes Schultz: https://t.co/1rkEJArFhH
Swasheck https://swasheck.github.io/2016-11-28-index-rebuild-reorg/
Marcin Gminski https://t.co/hwd2Kuq6i3
Greg Moore https://t.co/sCowdWifmY
Eduardo Pivaral https://www.mssqltips.com/sqlservertip/5748/start-and-stop-extended-events-sessions-automatically-using-sql-server-agent-jobs/
DBATools https://t.co/LIgB6JaHBA
Gianluca Sartori https://t.co/AJTHp1tv6r
Aaron Bertrand https://t.co/Pt4gQ4pTtQ
Erin Stellato https://t.co/HUK0okH8Oz
Jason Brimhall https://jasonbrimhall.info/2015/09/08/learning-extended-events-in-60-days/
Eric Cobb https://t.co/YvwFgrJJUe
Dave Mason https://t.co/MCIqUVQkfa
Thanks to everyone who submitted a post or a link. You’ve done some amazing work. I’m really happy to be able to share it with others.
If anyone else out there would like to see their work with Extended Events promoted, it’s not too late to get added to the list for my sessions.
Thanks for the resources, Grant!
Here’s a post that I wrote on the subject:
https://eitanblumin.com/2020/03/09/finding-details-missing-sql-server-failed-logins-audit/
Excellent! Thanks for sharing.
Is it possible to catch all errors and at the same time catch the variables used? Like a combination of sqlserver.error_reported and rpc_started?
I’d have to experiment, but I don’t see why not. Toss in causality tracking and you can pretty easily have a mechanism for getting exactly that. The only thing I’d need to figure out here would be how to filter so it only captures on the error occurring and not all the time. Probably simple if i looked at it. However, short answer, sure. That should absolutely work.