Using SQL Server Extended Events

Discussions, examples and general news about SQL Server Extended Events from the team that built it.

Extended Events demos on Microsoft Virtual Academy

I had an opportunity recently to contribute a presentation to the Microsoft Virtual Academy as part...

Author: Mike Wachal - MSFT Date: 03/28/2012

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

Author: Mike Wachal - MSFT Date: 02/17/2012

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

Author: Mike Wachal - MSFT Date: 01/03/2012

Introducing the Extended Events Reader

Check out What's new for Extended Events in SQL Server Codenamed "Denali" CTP3 for an...

Author: Mike Wachal - MSFT Date: 07/20/2011

Introducing the Extended Events User Interface

Check out What's new for Extended Events in SQL Server Codenamed "Denali" CTP3 for an overview of...

Author: Mike Wachal - MSFT Date: 07/13/2011

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

Author: Mike Wachal - MSFT Date: 07/13/2011

Sampling SQL server batch activity

Recently I was troubleshooting a performance issue on an internal tracking workload and needed to...

Author: Jerome Halmans Date: 02/10/2011

Migrating from SQL Trace to Extended Events

In SQL Server codenamed “Denali” we are moving our diagnostic tracing capabilities forward by...

Author: Mike Wachal - MSFT Date: 12/10/2010

Session memory – who’s this guy named Max and what’s he doing with my memory?

SQL Server MVP Jonathan Kehayias (blog) emailed me a question last week when he noticed that the...

Author: Mike Wachal - MSFT Date: 12/07/2010

Be sure to read Jonathan Kehayias’ 31 day series on extended events

If you have not seen it already, Jonathan Kehayias is writing a 31 day series on extended events in...

Author: Mike Wachal - MSFT Date: 12/03/2010

What’s new for Extended Events in SQL Server code-named “Denali” CTP1

I’ve been generally lax about posting new stuff to the blog for the last several months, and I’m...

Author: Mike Wachal - MSFT Date: 11/18/2010

Introducing your Data Collector to Extended Events

One of the things I haven’t gotten around to blogging about yet is how to utilize Data...

Author: Mike Wachal - MSFT Date: 07/21/2010

Take it to the MAX (and beyond)

I got an interesting question from our Support team today and thought I’d blog the answer since it...

Author: Mike Wachal - MSFT Date: 06/28/2010

Today’s Subject: Predicates

Don’t worry, I haven’t suddenly switched the topic of this blog to English grammar, but...

Author: Mike Wachal - MSFT Date: 06/23/2010

Try a sample: Using the counter predicate for event sampling

Extended Events offers a rich filtering mechanism, called predicates, that allows you to reduce the...

Author: Mike Wachal - MSFT Date: 05/14/2010

Making a Statement: How to retrieve the T-SQL statement that caused an event

If you’ve done any troubleshooting of T-SQL, you know that sooner or later, probably sooner, you’re...

Author: Mike Wachal - MSFT Date: 05/07/2010

Introduction to Extended Events

For those fighting with all the Extended Event terminology, let's step back and have a small overall...

Author: pedrou Date: 04/14/2010

Option Trading: Getting the most out of the event session options

You can control different aspects of how an event session behaves by setting the event session...

Author: Mike Wachal - MSFT Date: 03/31/2010

Extended Blogs – Now cross posting to Sqlblog.com

Thanks to some help from SQL MVP Adam Mechanic, the Extended Events blog is now being cross posted...

Author: Mike Wachal - MSFT Date: 03/17/2010

Reading event data 101: What’s up with the XML?

If you explored extended events to any degree you’ve already discovered that when you read the...

Author: Mike Wachal - MSFT Date: 03/08/2010

Welcome to the Extended Events blog

If you haven’t gotten a chance to explorer Extended Events yet, then you’ll probably want to read...

Author: Mike Wachal - MSFT Date: 03/08/2010