Chapter 40

Extended Events

In This Chapter

Understanding the Extended Event Object Model

Using the system_health Session

Discovering Extended Events Enhancements

Using the Extended Events Profiler

Extended Events, which debuted in SQL Server 2008, is a general event-handling system that you can use to diagnose and troubleshoot issues inside the SQL Server database engine. The main design goals of the Extended Events engine are to ensure that the overhead it produces on the system is at a minimum and that it is as scalable and extensible as possible.

This chapter is an overview of the Extended Events object model as well as the many new features added to Extended Events in SQL Server 2012.

Note
SQL Trace is now deprecated in SQL Server 2012. Extended Events will be the tool of choice to use in the future versions of SQL Server for tracing and troubleshooting SQL Server events.

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial