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 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.