Extended Events demos on Microsoft Virtual Academy

I had an opportunity recently to contribute a presentation to the Microsoft Virtual Academy as part of the Mission Critical Confidence using SQL Server 2012 course offering. The MVA offers you a myriad of free training opportunities, so I encourage anyone who is interested in expanding your knowledge to take advantage of this offering. For…


Issues with the system_health session in SQL Server 2012

The ever alert Jonathan Kehayias (Blog | Twitter) sent me a question recently asking about the Extended Event UI used for showing predicates. In particular, he was wondering about the predicate for the wait_info event that is defined in the system_health session and was wondering what was going on. It’s obvious what peaked Jonathan’s interest…


Activity Tracking event session template is broken

With the release of SQL Server 2012 RC0 you will notice that a number of new session templates have shown up in both the New Session Wizard and the New Session dialog. One template in particular, Activity Tracking, is unfortunately broken “out of the box.” We found this problem too late to be able to…


Introducing the Extended Events Reader

Check out What’s new for Extended Events in SQL Server Codenamed "Denali" CTP3 for an overview of all of the new functionality released in CTP3. This post covers the details of the “reader” API, which we call the XeReader, that you can use to programmatically access both XEL files and the near-live event stream from…


Introducing the Extended Events User Interface

Check out What’s new for Extended Events in SQL Server Codenamed “Denali” CTP3 for an overview of all of the new functionality released in CTP3. This post details the new user interface. In my overview post I mentioned that the user interface is built directly into management studio (SSMS) and that there are four parts:…


What’s New for Extended Events in SQL Server Codenamed “Denali” CTP3

CTP3 is finally here and the crowd goes wild! Since I’m sure everyone has been anticipating the CTP3 updates to Extended Events (because, let’s face it, Extended Events is the most important part of the product, right?) let’s get to it. Introduction I’m going to cover the new features at a high level in this…


Sampling SQL server batch activity

Recently I was troubleshooting a performance issue on an internal tracking workload and needed to collect some very low level events over a period of 3-4 hours.  During analysis of the data I found that a common pattern I was using was to find a batch with a duration that was longer than average and…

0

Introducing the Extended Events Object Model

The primary focus we’ve had for Extended Events in SQL Server codenamed “Denali” is to offer a better user experience by providing options for working with the system beyond DDL. One of those options is the availability of a managed code object model. In this post I’ll describe the object model and it’s usage as…


Migrating from SQL Trace to Extended Events

In SQL Server codenamed “Denali” we are moving our diagnostic tracing capabilities forward by building a system on top of Extended Events. With every new system you face the specter of migration which is always a bit of a hassle. I’m obviously motivated to see everyone move their diagnostic tracing systems over to the new…