Learning Extended Events in 60 Days

This post will serve as the landing page for a series I am calling 60 Days of Extended Events. The purpose of these posts will be to help somebody progress through the Extended XEisFutureEvents Concepts and become more proficient at implementing and using them.
The 60 days of XE will be a two month series running from September 1, 2015 through October 30, 2015. The posts will go live only on weekdays. So while it is 60 calendar days, it will end up being somewhere in the neighborhood of 45 articles. These are the  types of articles designed to take 5 to 15 minutes to learn a concept and move on with the work day. The articles are designed to build on previous concepts.

As the posts go live, I will return and update this page with the article title and link.

  1. Shredding the Actions attached to an Extended Event – 01 September 2015
  2. How to View the Metadata for Deployed Extended Event Sessions – 02 September 2015
  3. How to View the Metadata for Running Extended Event Sessions – 03 September 2015
  4. Some Supporting Objects of Extended Events – 04 September 2015
  5. Packages as they Relate to Extended Events – 07 September 2015
  6. What is an Object in Extended Events? – 08 September 2015
  7. Categorization within Extended Events – 09 September 2015
  8. Introduction to Events within Extended Events – 10 September 2015
  9. The Anatomy of an Event – 11 September 2015
  10. Extended Events and Fixed Schemas – 14 September 2015
  11. Actions in Extended Events – 15 September 2015
  12. Storing/Consuming Event Payloads – 16 September 2015
  13. Data Types for your Event Payloads – 17 September 2015
  14. Custom Data / Maps / Lookup Tables for your Event Payloads – 18 September 2015
  15. Predicates and Event Data – 21 September 2015
  16. Comparison Predicates – 22 September 2015
  17. Predicate Order is Critical – 23 September 2015
  18. Putting it all together into a Session – 24 September 2015
  19. Extended Events GUI – 25 September 2015
  20. Deployed Session Settings – Metadata – 28 September 2015
  21. Deployed Session Metadata for Events – 29 September 2015
  22. Deployed Session Metadata for Actions – 30 September 2015
  23. Deployed Session Metadata for Targets – 01 October 2015
  24. Set Operations and Metadata – 02 October 2015
  25. Backup Deployed Sessions – 05 October 2015
  26. Extended Event Management Power Tools – 06 October 2015
  27. XEvent Metadata via PoSH – 07 October 2015
  28. Action and Predicate Metadata with PowerShell – 08 October 2015
  29. Target Metadata with PowerShell – 09 October 2015
  30. Simplified Session Backups – 12 October 2015
  31. Intro to Reading Event_file Data – 13 October 2015
  32. Dynamically Read event_file Data – 14 October 2015
  33. Better Practices for Reading Event_file Targets   – 15 October 2015
  34. Jumping into the ring_buffer – 16 October 2015
  35. Know before you Go – Target Settings – 19 October 2015
  36. Matching Events into Pairs – 20 October 2015
  37. Parsing Matched Events – 21 October 2015
  38. Using and Reading the Histogram – 22 October 2015
  39. Bean Counting and Events – 23 October 2015
  40. Seeing Short-Circuiting at Work – 26 October 2015
  41. Intro to Internals Via XEvents – 27 October 2015
  42. Azure SQL DB and XE – 28 October 2015
  43. Default Sessions – 29 October 2015
  44. Tricks and Treats with XE – 30 October 2015 (Happy Halloween)

At the end of this two month series, there is still just too much to cover. Since I have plenty more in my queue, I have decided to extend the series into overtime. I have no guarantees on how many more posts I will add to the series from here, but I will continue to add more into the series until the queue is depleted.

  1. Log Files from Different Sources – 30 December 2015
  2. Customize The XEvent Log Display – 31 December 2015
  3. Filtering Logged Data – 01 January 2016
  4. Hidden GUI Gems – 02 January 2016
  5. A Day in the Stream – 04 January 2016
  6. Waiting, is it a Bad Thing? – 04 January 2016
  7. Alter Event Session – 07 January 2016
  8. Extended Event Help Queries – 19 July 2016
  9. Query to Find the Right Event – 21 July 2016
  10. Better Method to Parse Session XML Data – 01 August 2016
  11. Using XEvents to Audit Queries – 08 August 2016
  12. Finding the Right Path – 24 August 2016
  13. Deprecated Features via XEvents – TBA
  14. TDE – TBA
  15. Encryption – TBA
  16. TBA – TBA
4 Comments - Leave a comment
  1. […] Learning Extended Events in 60 Days September 8, 2015 […]

  2. […] Learning Extended Events in 60 Days September 8, 2015 […]

  3. MK says:

    Hi Jason! Thank you for these great articles! When you have a moment, please review links for #20 and #21. I believe they point to the same article, and 21 should be pointed to http://jasonbrimhall.info/2015/09/29/session-event-metadata/.

    Hope this feedback is helpful!

Leave a comment

Your email address will not be published. Required fields are marked *










Calendar
September 2015
M T W T F S S
« Aug   Oct »
 123456
78910111213
14151617181920
21222324252627
282930  
Content
SQLHelp

SQLHelp


Welcome , today is Tuesday, September 27, 2016