SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Deployed Action and Predicate Metadata with PoSH

I have recently shown that using PowerShell can be extremely powerful in obtaining insight into how to investigate deployed Extended Event Sessions. Throughout the demos I have used, I hope that it has also shown that PowerShell can be very easy to use.

Querying this metadata through TSQL is… Read more

0 comments, 354 reads

Posted in SQL RNNR on 8 October 2015

Exposing Deployed Event Metadata with PoSH

In the last article I introduced a power tool that can be used to help manage Extended Events. That tool is PowerShell. In that article, I focused primarily on introducing PowerShell as a power tool to help in discovering the Extended Event Sessions deployed to the server as well… Read more

0 comments, 288 reads

Posted in SQL RNNR on 7 October 2015

Extended Event Management Power Tools

So far in this series I have introduced a couple of tools that are suitable for helping with the management of Extended Events. The tools introduced so far are the GUI and TSQL scripts. While the GUI is suitable, using a script really is a far better means of managing… Read more

0 comments, 343 reads

Posted in SQL RNNR on 6 October 2015

Backup Deployed Sessions

There is a wealth of information within Extended Events. Throughout this series, I have been working on exposing that wealth of information. A good bit of this information happens to be the metadata for Extended Events, and another bit of this information is tied to the metadata for deployed Sessions.… Read more

0 comments, 335 reads

Posted in SQL RNNR on 5 October 2015

SET Operations and Metadata

Having covered the core concepts of deployed session metadata (events, actions, targets, predicates), there is one more topic to cover. This is more of a subset of those concepts in that this applies to more than one of the core concepts, but it isn’t really a stand-alone topic. This is… Read more

1 comments, 345 reads

Posted in SQL RNNR on 2 October 2015

Session Target Metadata

With the ability to find the metadata for deployed session, events and actions firmly under the belt, the natural progression would lead one to find the metadata for the target(s) attached to a session.

Exploring the metadata for the core components of Extended Events Sessions can be an extremely fruitful… Read more

2 comments, 376 reads

Posted in SQL RNNR on 1 October 2015

Session Action Metadata

In a previous article, I introduced the core concept of Actions. In that article, I explained that an Action is a means to attach additional data from the stream to the event payload.

Recently, I have been covering various aspects of how to build an event session as well… Read more

2 comments, 526 reads

Posted in SQL RNNR on 30 September 2015

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. I started to dive into the investigation of this metadata with the exploration of the Deployed Extended Event Session Settings discussed here.… Read more

2 comments, 1,159 reads

Posted in SQL RNNR on 29 September 2015

Deployed Session Settings

You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking about deployed sessions again. And it may even be considered metadata as well. This time around, the metadata I will be discussing is a little bit different but will build… Read more

2 comments, 947 reads

Posted in SQL RNNR on 28 September 2015

The Extended Event GUI

In the previous article in this series I shared the basics around assembling an XEvent session. The method used in that article was via TSQL script. In this article, I will introduce the Extended Events GUI. While I prefer to use TSQL to create and manage my sessions, the… Read more

2 comments, 1,918 reads

Posted in SQL RNNR on 25 September 2015

Assembling a Session

Up to this point, I have taken a lot of time to discuss the various components of Extended Events. There is good reason for that. The components I have discussed are essential pieces of Extended Events and are critical to building useful sessions.

Previously, I only touched lightly on the… Read more

1 comments, 323 reads

Posted in SQL RNNR on 24 September 2015

Freecon – Oct 27 in Seattle

Just over a week ago I announced that SQL Solutions Group was getting ready to host a day of training, FREECON if you will, in Seattle as a prelude to the PASS Summit of 2015. You can read all about that here, with registration being here.

While I… Read more

0 comments, 524 reads

Posted in SQL RNNR on 23 September 2015

Predicate Order is Critical

I have mentioned predicate order previously and wanted to make sure I 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.

The proper order of a predicate… Read more

0 comments, 2,918 reads

Posted in SQL RNNR on 23 September 2015

Comparison Predicates and Event Data

In the previous installment, I began covering the topic of predicates. In that article I demonstrated that there are multiple types of predicates. There are two objects that fall into the predicate category and then there are data comparison predicates (those that are not objects).

The two objects are pred_compare… Read more

0 comments, 411 reads

Posted in SQL RNNR on 22 September 2015

Predicates and Event Data

At one time or another, a predicate has been the best friend or worst enemy of the data professional. If the predicate was forgotten during an update for a specific user account, then the predicate suddenly became the worst enemy. On the other hand, when the predicate was properly used… Read more

2 comments, 393 reads

Posted in SQL RNNR on 21 September 2015

Map Data Types in Extended Events

In the last segment, I wrote about the data types for the payload of an event in Extended Events. In that article, I also mentioned there is another component that is like a custom data type. That component is a map.

Maps are like a way of overloading the data… Read more

1 comments, 299 reads

Posted in SQL RNNR on 18 September 2015

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.

To a small degree, I introduced the topic when I wrote about event payloads. And I also did a very quick… Read more

0 comments, 371 reads

Posted in SQL RNNR on 17 September 2015

Storing Event Data

Among the several core concepts of Extended Events is the concept of storing event payloads / data. When an event fires, it would not be far-fetched to want to be able to review that data at some time after the fact. How often are you sitting there watching the system… Read more

0 comments, 412 reads

Posted in SQL RNNR on 16 September 2015

Free SQL Training in Seattle

The annual SQL Server Professional migration is about to begin. Many of us will be descending upon the city of Seattle for a week of training and networking at the PASS Summit. The week in Seattle will invariably begin and end on different days for many people. And since… Read more

1 comments, 438 reads

Posted in SQL RNNR on 15 September 2015

Actions In Extended Events

The next component to discuss is Actions. I have discussed various aspects of events, schemas, categories and packages as some of the core concepts of Extended Events. Actions, is another of the core concepts.

In grammar, an action invokes memories of verbs and “to do” something. If you recall from… Read more

1 comments, 394 reads

Posted in SQL RNNR on 15 September 2015

Newer posts

Older posts