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...
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...
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...
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...
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...
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...
Date: 07/13/2011
Sampling SQL server batch activity
Recently I was troubleshooting a performance issue on an internal tracking workload and needed to...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 03/08/2010