Microsoft® SQL Server® 2012 Bible

938

Part VII: Monitoring and Auditing

FIGURE 40-1

This fi gure lists all objects in the Extended Events object model.

Extended Events Engine

Registered

Packages

and

Metadata

Event

Sessions

Events

Events Actions Types Maps

Dispatcher

Pool

Dispatcher

Buffers

Targets

Targets Predicates

Packages

The Extended Events objects exist inside of modules called Packages. At the top level,

Extended Events organizes its components into nine separate packages, not all of which

you can interact with directly. Following are the three packages you’re most likely to deal

with:

■ The Package0 package provides base functionality used by the other packages.

■ (^) The sqlos package works with the SQLOS events.
■ The sqlserver package works with the rest of SQL Server. In SQL Server 2012
there are actually two different sqlserver packages.
Each of these packages contains several objects. To see the full list of objects within
packages, use the following DMV query:
SELECT
PackageName = p.name, EventName = o.name,
EventDescription = o.description
FROM sys.dm_xe_objects o
JOIN sys.dm_xe_packages p ON o.package_guid = p.guid
ORDER BY p.name, o.object_type
c40.indd 938c40.indd 938 7/31/2012 10:02:41 AM7/31/2012 10:02:41 AM
http://www.it-ebooks.info