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

Archives: 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,805 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, 528 reads

Posted in SQL RNNR on 7 September 2015

XEvent Session Supporting Cast

So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated some quick and simple means to retrieve some metadata via the catalog views and DMVs.

Beyond the metadata in the the catalog views and DMVs, there are a… Read more

1 comments, 971 reads

Posted in SQL RNNR on 4 September 2015

Viewing Running XEvent Metadata

In the previous article, I wrote about getting into some of the metadata to take a peek at session metadata relevant to deployed Extended Event sessions. Today, I will continue talking about metadata. One difference being that today I will focus on diving into the metadata of running sessions. Read more

2 comments, 1,304 reads

Posted in SQL RNNR on 3 September 2015

Viewing Deployed XEvent Metadata

Today will be the first of a few introductory level posts about Extended Events.

When dealing with Extended Events, there are a few ways to take a look some of the metadata. Not all metadata is created equal when dealing with Extended Events. Some of the metadata is pertinent to…

Read more

6 comments, 683 reads

Posted in SQL RNNR on 2 September 2015

Shredding Extended Event Actions

The other day I wrote about that torrid love/hate relationship DBAs tend to have with working with XML. In that same post, I promised I would have a follow up post about XML in Extended Events.

Well, today I present to you another opportunity for you to renew your love/hate… Read more

1 comments, 745 reads

Posted in SQL RNNR on 1 September 2015

Newer posts