While my relationship with Extended Events is complicated for many reasons:
- Awful documentation
- Hardly any guidance on usage
- Almost nothing useful about what type of target to use when
- Everything stored in XML
- Slow, unfriendly GUI in SSMS
My need to use them while consulting outweighs my gripes and grievances about how Microsoft has chosen to write about, use, and present the data to you.
That’s where my stored procedure sp_HumanEvents comes in handy.
In fairness, Erik put his virtual money where his virtual mouth is, and sp_HumanEvents is put together quite well.