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. 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.
Bob Beauchemin is a database-centric application practitioner and architect, instructor, course author, writer, and Developer Skills Partner for SQLskills. Over the past few years he's been writing and teaching his SQL Server 2005-2012 courses to students worldwide through the Ascend program, the Metro (SQL Server 2008 Jumpstart) program, and other database developer-centric classes. He is lead author of the books "A Developer's Guide to SQL Server 2005" and "A First Look at SQL Server 2005 For Developers", author of "Essential ADO.NET" and has written articles on SQL Server and other databases, database security, ADO.NET, and OLE DB for MSDN, SQL Server Magazine, and others.