Now that some of the basics concerning how to access Extended Events via PowerShell have been covered, it is appropriate to start digging in a little deeper. This deeper dive will continue in the direction of Exposing Deployed Event Metadata with PoSH and familiarity with this powerful tool.
Tag: XE
Extended Event Management Power Tools
PowerShell can pack a pretty big punch when dealing with Extended Events. Using PowerShell as one of your Extended Events Management Tools, there could be a bit of a learning curve, and it may not be the right tool all the time, but it can sure pack a big hit.
Backup Deployed Sessions
Having just completed several segments on the metadata for deployed sessions, it is time to bring all of that information together and see how it can be used – by showing how to backup deployed sessions.
SET Operations and Metadata
SET operations in extended events are the extra configurations that can be made to various components. As an example, a target can be configured with certain properties via the use of a SET operation when creating the Extended Event Session. The best way to see the SET Options and Metadata, is by seeing it in action.
Session Target Metadata
In the case of the final core component, Targets, the exploration into the metadata can be a little awkward. At least at first. Read on to see how to explore the deployed session target metadata at a preliminary level.
Session Action Metadata
Knowing how to access the deployed session metadata and the event metadata attached to that session, I will now begin the dive into how to find the same relevant data for any deployed session action metadata.
Session Event Metadata
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.