Microsoft® SQL Server® 2012 Bible

937

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 Profi ler

E

xtended 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.

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.

The Extended Events Object Model

The Extended Events engine is a collection of services and objects that enable and manage events

and event processing inside of the SQL Server database engine. The Extended Events engine

does not provide any of the events or the actions to take when events are fi red. The information

associated with the events and the objects associated with events lie in the object model shown in

Figure 40-1.

c40.indd 937c40.indd 937 7/31/2012 10:02:39 AM7/31/2012 10:02:39 AM

http://www.it-ebooks.info