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

Archives: October 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, 1,014 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, 1,059 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, 729 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, 577 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, 595 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, 487 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,725 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, 685 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, 625 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, 617 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,640 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, 593 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, 510 reads

Posted in SQL RNNR on 14 October 2015

Auditing Needs Reporting


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 Sebastian Meine (blog / twitter), and the topic that he wants us to write… Read more

0 comments, 679 reads

Posted in SQL RNNR on 13 October 2015

Intro to Reading Event_File Target Data

Having covered the metadata for a deployed session from just about every angle (yes there is more on metadata that could be discussed, has not yet been discussed, and that I am not planning on covering at this time), it is high-time to start figuring out how to query the… Read more

0 comments, 545 reads

Posted in SQL RNNR on 13 October 2015

Simplified Session Backups

PowerShell exposes scads of information and provides the professional with a formidable tool for the tool-belt. Over the past several articles, I have demonstrated how this tool can be used to uncover useful information and metadata.

The groundwork has been laid to be able to mine information about each of… Read more

0 comments, 474 reads

Posted in SQL RNNR on 12 October 2015

Deployed Target Metadata with PoSH

Having just covered the methods to discover the metadata for a deployed session including the details about the session settings, events, actions, and predicates, I am nearly finished with the session metadata. All that remains is to dive into the metadata for Targets.

Through the articles thus far, I have… Read more

0 comments, 549 reads

Posted in SQL RNNR on 9 October 2015

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, 557 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, 498 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, 589 reads

Posted in SQL RNNR on 6 October 2015

Older posts