943
Chapter 40: Extended Events
40
Viewing the properties for a given session details the events for the session along with any
predicates, actions, and targets associated with the session. You can modify the session as
necessary using this user interface. See Figure 40-3.FIGURE 40-3
You can use the Extended Events user interface in SQL Server 2012 to create new Event
Sessions as well as modify existing Event Sessions.When creating a new session, you have the option to use the New Session Wizard or use the
New Session dialog. The main difference between the two is that the wizard is more similar
to the dialog you would see when you designed a Trace in SQL Server Profi ler. With the wiz-
ard, you have two options for Targets: a fi le destination and a Ring Buffer. Also, Predicates
are created session-wide. This is substantially different than the New Session Dialog where
you can use any of the available Targets and can set Predicates at the Event level.A useful option when defi ning an Extended Events Session is to use the built-in templates.
Similar to the templates exposed in SQL Trace Profi ler, the Extended Events templates are
built with a specifi c purpose; such as fi nding high duration locking or exposing database
fi le IO problems, etc. You can also defi ne an Extended Events Session and save that defi ni-
tion as a template.c40.indd 943c40.indd 943 7/31/2012 10:02:41 AM7/31/2012 10:02:41 AM
http://www.it-ebooks.info