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…