Extended Events

Extended Events were first introduced in SQL Server 2008 as a general event infrastructure to provide debugging and diagnostics capabilities for various purposes. The lack of UI support for Extended Events in SQL Server 2008 made for a steep learning curve of all the new concepts introduced by Extended Events for even simple tracing. Although Extended Events exposed a number of new events that were never available in SQL Trace, it was missing a large number of the trace events required for normal day-to-day usage.

In SQL Server 2012, Extended Events has been expanded significantly and now contains all the events formerly available in SQL Trace as well as a new UI implementation in SQL Server Management Studio. SQL Trace also has ...

Get Microsoft SQL Server 2012 Internals now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.