The predicate order is critical. Having the wrong order can result in not trapping the desired events. I cover the critical nature of predicates in the aforementioned article. At least in principle. Today, I want to reinforce the topic through the use of examples.
Counting Events
This article will show how to implement an XEvent Session that employs the use of the event_counter target that is used for counting events. IN addition, you will be shown how to parse the data and get some meaningful counts of event occurrences in your SQL Server Instances.
Histograms and Events
In this article I show how to use and configure the histogram target. In addition, I explain how to get to the data trapped into this target. Lastly, I demonstrate how to find the pertinent information for the target configurations.
Parsing Matched Events
In this article I will be taking you into the world of the pair_matching target. The pair_matching target should connote that this target works on matching like events into a single pair. Very much like a pair of socks would contain two parts, one for each foot or side of the body, the pair_matching target creates pairs of events that go together.
Matching Events into Pairs
In this article I will be taking you into the world of the pair_matching target. The pair_matching target should connote that this target works on matching like events into a single pair. Very much like a pair of socks would contain two parts, one for each foot or side of the body, the pair_matching target creates pairs of events that go together.