THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.

TechEd Coming Up - Recommended Background for My Extended Events Talk

TechEd North America 2009 is just a few short weeks away, and I'm really looking forward not only to the show, but also the opportunity to visit Los Angeles for the first time in several years.  I'm busy putting the finishing touches on my Extended Events talk, DAT402, "Microsoft SQL Server 2008: Performance Profiling and Troubleshooting with Extended Events", and I thought I should write a quick note to anyone out there who is thinking of attending. 

What's noteworthy about this talk is that the TechEd team modified the title a bit and removed the word "Advanced", but left the talk at 400-level and also left the original abstract untouched:

Imagine tracking and aggregating wait statistics at the session level rather than the server level. Imagine seeing exactly how long each step in your query took and figuring out the real cost of that index scan. Imagine capturing an exception with an associated callstack--no more guessing about exactly what component failed and why. When you're done imagining, open your eyes and attend this session to learn all of these techniques and more, all thanks to Extended Events (XEvents)--the powerful new tracing infrastructure in SQL Server 2008. Designed for DBAs and developers who already understand the basics of XEvents, this session goes from 0 to 60 in the first few minutes. See a number of code examples and gain an understanding of how to maximize XEvents for performance profiling and troubleshooting purposes. If you're serious about making your SQL Servers fly, this is one session not to be missed.

When I gave this same talk earlier this year at SQL Server Connections in Orlando, some attendees apparently didn't understand that it really is an advanced talk, and showed up without quite enough background to follow along as well as they could have.  I'm hoping to minimize that phenomenon at TechEd; so please keep in mind that although I do a quick (five-minute) refresher, that's it, and Extended Events is a much bigger topic than can be fully introduced in five minutes.  Once the refresher part is over I jump into four fairly intense, demo-heavy deep-dive sections, so please, if you want to get your money's worth, make sure that you read one or more of the following in the next few weeks:

Reading through these sources will give you the background so that you can focus on the performance troubleshooting aspects of the talk, rather than sitting there bogged down in the unfamiliar Extended Events syntax and terminology.

I'm looking forward to meeting some SQLblog readers at the event; if you're attending, even if you decide to skip my Extended Events talk, stop by the Database Practices TLC and say hi.  Looking forward to seeing you in LA!

Published Wednesday, April 22, 2009 10:46 PM by Adam Machanic
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Peso said:

Well, LA is half around the world for me so the chance is very slim.

I'll say "Hi" here instead :-)

April 23, 2009 1:13 AM

Michael Zilberstein said:


Will your presentation be publicly available at some time? I'm VERY interested - couple of months ago I talked about performance monitoring with Extended Events at Israeli SQL Server Usergroup but it was mere introduction, level 200. Synchronous and asynchronous targets and all that sort of things, just the capabilities, not real life scenarios.

April 25, 2009 8:29 AM

Adam Machanic said:

Hi Michael,

It will be recorded at TechEd but I don't know if they'll publish it on the Web or anything like that.  I'll let you know if they do.  

April 26, 2009 8:58 PM

Michael Zilberstein said:


April 27, 2009 9:30 AM

Leave a Comment


About Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

This Blog


Privacy Statement