Know Before You GO – Target Settings

When adding a Target to a session, a configurable setting may or may not be obviously available for use with the Target. In and of itself, this can be...

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...

Reading Session Data from Memory

In this article, I introduce the topic of reading session data from memory along with some of the pitfalls and some words of caution.
Related Posts:

How to: File Target use...

Better Practices for Reading Event_file Targets

In this article, I am going to address some better practices for Reading Event_file targets attached to an XEvent Session.
Related Posts:

How to: File Target use in Extended Events December...

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...

Dynamically Read event_file Data

There needs to be a more efficient means of grabbing the file without having to know the location. Knowing the session name should be adequate enough to parse the...

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...

Auditing Needs Reporting

No matter the mechanism used to capture the data to fulfill the "investigation" phase of the audit, if the data is not analyzed and reports generated, then the audit...

Auditing Needs Reporting

 
Welcome to the second Tuesday of the month. And in the database world of SQL Server and the SQL Server...

Intro to Reading Event_File Target Data

The event_file target is an asynchronous consumer for Extended Events. This target stores the received payload in a proprietary binary format. Because of this, one needs to use the...