SQLBits 2012

Extended Events and the new Profiler in SQL Server 2012

Extended Events made its appearance in SQL Server 2008, but in SQL Server 2012, the number of lightweight events have been expanded. After a quick review of how Extended Events work, I’ll cover the enhancements in detail.
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.