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

Alter Event Session

Ready for a change of pace? Good! Today is a really good time to start looking into one of the more basic concepts related to Extended Event Session management.

Consider the occasional need to change a trace. Maybe you added the wrong event to the trace, or maybe you neglected… Read more

0 comments, 1,509 reads

Posted in SQL RNNR on 8 January 2016

Waiting, is it a Bad Thing?

Despite the desire to get away from the GUI talk in these articles about Extended Events, I have so far been unable to do it. Each article of late has something more to deal with the user interface. Let’s see what we can do with the GUI today.

One of… Read more

0 comments, 578 reads

Posted in SQL RNNR on 6 January 2016

A day in the Stream

Enough talk of the GUI with Extended Events (see previous articles in the series if you want to revisit the stickiness of the GUI – here). It is time for a bit of a diversion and something quick.

While it may be a quick traipse today, it won’t be… Read more

4 comments, 382 reads

Posted in SQL RNNR on 5 January 2016

Hidden GUI Gems

The GUI for Extended Events offers some power to help you get started with trying to work with Extended Events. As I have shown over the past few articles, some of this power comes with a bit of cost and may in fact not be as powerful as just using… Read more

0 comments, 1,229 reads

Posted in SQL RNNR on 2 January 2016

Filtering Logged Data

Over the course of the past couple of articles, I have shown some interesting if not useful functionality in the user interface for working with Extended Event log files. Those articles on merging files and customizing the view can be read here and here.

Today, I am going to… Read more

0 comments, 1,054 reads

Posted in SQL RNNR on 1 January 2016

Customize the XEvent Log Display

In the previous article I showed a couple of methods to merge Extended Event Log files. In that article I mentioned the ability to customize the display in the GUI for the merged log files.

Today, I am going to explore how to configure the GUI with filters and… Read more

1 comments, 583 reads

Posted in SQL RNNR on 31 December 2015

Log Files from Different Sources

Well, it has been quite a pause between articles in the series. It is well past time to continue the series. With such a delay in the series, it is prudent to remind all that there is a series on Extended Events I had done over the course of two… Read more

1 comments, 1,417 reads

Posted in SQL RNNR on 30 December 2015

Tricks and Treats with XE

Halloween is a great time of year. It is unfortunate that it is just one day of the year. That said, I do like to think of the month of October as Halloween Month. I have several posts over the years that geek out over the cross-over between Halloween and… Read more

0 comments, 624 reads

Posted in SQL RNNR on 30 October 2015

Default Sessions

So I have blasted through a lot of technical articles about Extended Events. There is a lot of groundwork that has been covered with layers of building blocks that have been stacked. Now it’s time to take a step back as I near the end of the original goal for… Read more

0 comments, 611 reads

Posted in SQL RNNR on 29 October 2015

Azure SQL Database

So far I have strictly focused on Extended Events for SQL Server installations. This means I have been looking at Extended Events from the “physical” or on-premises perspective. Installing SQL Server into an Azure VM falls into this category as well.

What hasn’t received any TLC is Extended Events from… Read more

1 comments, 511 reads

Posted in SQL RNNR on 28 October 2015

Exposure to Internals

For me, some of the most fun stuff with SQL Server is diving deep into the internals. Diving into the internals is not always an easy adventure. Sometimes, it requires a lot of trial and error sometimes. There are times where a dive into the internals can get me “into… Read more

0 comments, 402 reads

Posted in SQL RNNR on 27 October 2015

Short Circuit Events

I introduced the importance about predicate order previously. I recommend either reading that article for the first time or reading it again if you have already read it. You can find that article – here.

The predicate order is critical. Having the wrong order can result in not trapping… Read more

0 comments, 430 reads

Posted in SQL RNNR on 26 October 2015

Counting Events

After reading through the articles about the pair_matching target (here) and the article on the histogram target (here), this one is going to seem very basic. To be honest, I would consider this to be basic even if it was discussed prior to the two just… Read more

1 comments, 337 reads

Posted in SQL RNNR on 23 October 2015

Histograms and Events

The last few articles covered the pair_matching target and some uses and details that go along with it. For a recap, you can read here.

The pair_matching target was just one of the more advanced targets available for use via Extended Events. In this segment, I will be covering… Read more

3 comments, 1,446 reads

Posted in SQL RNNR on 22 October 2015

Parsing Matched Events

I just covered the topic of matching events from definition on down through highlighting a common use for this type of target. With that in mind, it is now time to dive into how to extract the data from the session.

If you need a recap of what exactly a… Read more

1 comments, 446 reads

Posted in SQL RNNR on 21 October 2015

Matching Events into Pairs

In the last article I showed how to discover all of the settings that are available to a particular Target. I also mentioned the reason for that being that I would be discussing some of the other Target types since I had already shown various concepts in regards to the… Read more

0 comments, 452 reads

Posted in SQL RNNR on 20 October 2015

Know Before You GO – Target Settings

The last few articles have covered various topics for the event_file and ring_buffer target. The topics range from basic queries in how to extract the session data on up through best practices. The fun doesn’t end there!

I will be covering more on the different types of targets over the… Read more

2 comments, 420 reads

Posted in SQL RNNR on 19 October 2015

Reading Session Data from Memory

In the last few articles I took you through a progression of working with the event_file target from the most basic concepts on through the more advanced. While working with the event_file target, I showed that XML is central to working with the session data for that target type. XML… Read more

2 comments, 1,444 reads

Posted in SQL RNNR on 16 October 2015

Better Practices for Reading Event_file Targets

I have demonstrated over the past couple of articles the basics involved with reading the
event_file target along with a more advanced technique.

In each of those articles I outlined some problems that could be encountered. Some of those pitfalls might include another DBA moving the location of the files… Read more

4 comments, 422 reads

Posted in SQL RNNR on 15 October 2015

Dynamically Read event_file Data

In the previous article I covered the basics on extracting the payload for the events in a session from the event_file target. That article was a basic introduction.

In this article I want to take that basic knowledge and take it one step further. Being able to extract the… Read more

3 comments, 308 reads

Posted in SQL RNNR on 14 October 2015

Newer posts

Older posts