Extended Events made its appearance in SQL Server 2008, but in SQL Server 2012, the number of lightweight events have been expanded. All of the events and fields available in SQL Profiler are now available in Extended Events as well as a graphic user interface, covering more use cases and enabling new debugging opportunities. After a quick review of how Extended Events work, I’ll cover the enhancements in detail. In addition to more events, Extended Events also exposed in the 2012 SQL Server PowerShell provider and SMO, and I’ll show working with Extended Events in PowerShell.
Slide Deck 907 KB , MP4 Video Low 65 MB , MP4 Video Med 83 MB , MP4 Video High 187 MB , MP4 Video HD 330 MB