- SET Operations and Metadata by Jason Brimhall
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 by Jason Brimhall
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 by Jason Brimhall
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 by Jason Brimhall
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 by Jason Brimhall
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 by Jason Brimhall
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 by Jason Brimhall
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 by Jason Brimhall
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.
- Predicate Order is Critical by Jason Brimhall
I want to drive home the importance of the predicate order when dealing with Extended Events. This is an important topic because it can be very helpful in maintaining a reasonably performing event monitoring system.
- Comparison Predicates and E… by Jason Brimhall
Predicates are a significant component within the Extended Events Engine. This article discusses one of the pieces of the puzzle of predicates – comparison operators – also known as pred_compare.
- Jason Brimhall about The Extended Event GUIThanks Hugo
- Hugo Shebbeare about The Extended Event GUIVery cool post Jason, I'm going to be using your great examples when refreshing our team's use of XE :)
- Jason Brimhall about Viewing Deployed XEvent MetadataIf you are running the session and storing the data. If you don't have the session running, you will not …
- Marios Phili… about Viewing Deployed XEvent MetadataHi, Thank you for this series of articles. I will certainly be following it. Is there a way to find historical information …
- Felix about What is DBCC?Jason, you are absolutely right! Before reading your complete article my answer is exactly same as you have mentioned. Thanks …
- Jason Brimhall about Compressing Encrypted BackupsJust a quick follow-up note. This is not testing TDE where the data would be encrypted "transparently" in the data …
- Jay about Can you partition a tempora…I was asked the same question once in my interview , i said yes but at that i dont know …
- Jason Brimhall about Table Size Script Update for 2015You must be on SQL 2012 or older. I should have left it more global to use between different versions. …
- Steve about Table Size Script Update for 2015In order to test your script i had to modify the indexing of tmp tables. Deffining the clustered indexes outside …
- Jason Brimhall about Adventures with NOLOCKI think you missed the point. The article was a quick demonstration to remind people that the NOLOCK directive is …