There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to know where and how to find it. In this article, learn how to explore the deployed session Event Metadata.
Deployed Session Settings
Deployed Session Settings are stored within the system databases and then exposed via system catalog views. These settings help define a session. This article shows how to access those settings and gives an introduction into what these settings mean.
The Extended Event GUI
The Extended Events GUI provides a visual access to the Extended Events engine that can help to better understand the XEvents Engine and how a Session is built.
Assembling a Session
With the core concepts in place as a good foundation to Extended Events, we start pushing these things together to help with assembling a session in Extended Events.
Freecon – Oct 27 in Seattle
It is well known that there is a wealth of information within Extended Events. One can tap plenty of information about performance issues, errors, or general interest type stuff by setting up an XEvent Session and trapping some (hopefully) useful information.