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.
Tag: XE
Comparison Predicates and Event Data
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.
Predicates and Event Data
A predicate is a filtering mechanism used in SQL Server to target specific data when either querying or updating rows.
Map Data Types in Extended Events
Maps are like a way of overloading the data type to expose more meaningful values that relate to the payload data in question. The standard data types can also be called scalar types with a single value (instead of a table lookup).
Data Types in Extended Events
Today I get to talk about data types within Extended Events. This also means, I hope to be able to bring a little more clarity to the topic.
Storing Event Data
Among the several core concepts of Extended Events is the concept of storing event payloads / data.
Actions In Extended Events
an action invokes memories of verbs and “to do” something. If you recall from the quick definition in the article on Extended Events Objects, an action is “a means to attach additional data to the payload of an event.”
Extended Events and Fixed Schemas
Working with databases, XML, and many software applications, it is not uncommon to deal with fixed schemas. In the database world, it is fairly fundamental to have some sort of schema. The schema represents the typing of the bit-strings that are being stored or presented. One might even call it the template.
Extended Events – Event Anatomy
As a follow-up to the introduction to what an Event is, it makes sense to discuss the components of an event. What makes up an event? What is the payload of the event? What is a payload?
Extended Events – Events
If you recall, an event is some point of interest that may or may not occur within an application. Obviously, if the event is triggered, then that point of interest has occurred.