Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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, 841 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,766 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, 224 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, 377 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,783 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, 290 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, 265 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, 233 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, 267 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, 257 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, 317 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, 274 reads

Posted in SQL RNNR on 15 September 2015

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… Read more

1 comments, 206 reads

Posted in SQL RNNR on 14 September 2015

Extended Events – Event Anatomy

So far in these brief discussions about Extended Events, I have covered several core concepts including a basic introduction into what an Event is within Extended Events. For a recap on those articles, you can read this.

As a follow-up to the introduction to what an Event is, it… Read more

0 comments, 255 reads

Posted in SQL RNNR on 11 September 2015

Extended Events – Events

After thrilling dives into the XEvent Core Concepts of packages, channels and objects, today we have the core concept of “Event.”

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… Read more

5 comments, 1,099 reads

Posted in SQL RNNR on 10 September 2015

Extended Events Categories

I recently delved into a brief explanation of Packages as they correlate to Extended Events. In that article, I left a couple of things un-said about packages – leaving them for this article.

Packages have a couple of descriptors (or classifiers) that can be useful to help figure out what… Read more

1 comments, 296 reads

Posted in SQL RNNR on 9 September 2015

One Easy Strategy for the Database Enterprise

 

Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server community, that means it is time for TSQL2SDAY. This month the host is Jen McCown (blog / twitter), half of the MidnightDBA team, and the topic that… Read more

1 comments, 300 reads

Posted in SQL RNNR on 9 September 2015

Learning Extended Events in 60 Days

This post will serve as the landing page for a series I am calling 60 Days of Extended Events. The purpose of these posts will be to help somebody progress through the Extended Events Concepts and become more proficient at implementing and using them.

The 60 days of XE will… Read more

2 comments, 407 reads

Posted in SQL RNNR on 8 September 2015

Extended Events Objects

So far, I have talked about some of the metadata associated with Extended Events. But I have not yet started to dive into the individual components of that metadata.

Today I want to start diving into some of this data a little deeper as we progress through some of the… Read more

3 comments, 1,394 reads

Posted in SQL RNNR on 8 September 2015

Extended Events Packages

Today, I continue on with exploring some of the metadata concerning Extended Events. To date, I have explored various aspects of session metadata whether the session is running or stopped. Today, I want to take a step back and look at the framework that helps give us this tool.

The… Read more

0 comments, 243 reads

Posted in SQL RNNR on 7 September 2015

Newer posts

Older posts