Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Extended Events Tools

You can use the following tools to create and manage SQL Server Extended Events sessions:

  • Data Definition Language (DDL) statements. These enable you to create and modify an Extended Events session.

  • Dynamic management views, catalog views and system tables. These enable you to obtain session data and metadata by using Transact-SQL statements. The system tables help you determine the existing Extended Events equivalents for SQL Trace event classes and columns.

  • The Extended Events node of Object Explorer. This enables you to start, stop or delete a session, or to import and export session templates.

  • The SQL Server PowerShell provider. This is a powerful tool that you can use to create, alter, and manage Extended Events sessions. For more information, see Use the PowerShell Provider for Extended Events.

  • SQL Server Management Studio. This enables you to create and execute the code samples that are provided in the Extended Events topics. For more information, see Object Explorer.

In addition to sessions that you create, a default system health session exists on the server. The session collects system data that you can use to help troubleshoot performance issues. For more information, see Use the system_health Session.

Use the following DDL statements to create, change, and drop an Extended Events session.

Name

Description

CREATE EVENT SESSION (Transact-SQL)

Creates an Extended Event session object that identifies the source of the events, the event session targets, and the event session parameters.

ALTER EVENT SESSION (Transact-SQL)

Starts or stops an event session or changes an event session configuration.

DROP EVENT SESSION (Transact-SQL)

Drops an event session.

Use the following catalog views to obtain the metadata that is created when you create an event session.

Name

Description

sys.server_event_sessions (Transact-SQL)

Lists all event session definitions.

sys.server_event_session_actions (Transact-SQL)

Returns a row for each action on each event of an event session.

sys.server_event_session_events (Transact-SQL)

Returns a row for each event in an event session.

sys.server_event_session_fields (Transact-SQL)

Returns a row for each customizable column that was explicitly set on events and targets.

sys.server_event_session_targets (Transact-SQL)

Returns a row for each event target for an event session.

Use the following dynamic management views to obtain session metadata and session data. The metadata is obtained from the catalog views, and the session data is created when you start and run an event session.

Note Note

  These views do not contain session data until a session starts.

Name

Description

sys.dm_os_dispatcher_pools (Transact-SQL)

Returns information about session dispatcher pools.

sys.dm_xe_objects (Transact-SQL)

Returns a row for each object that is exposed by an event package.

sys.dm_xe_object_columns (Transact-SQL)

Returns the schema information for all the objects.

sys.dm_xe_packages (Transact-SQL)

Lists all the packages registered with the Extended Events engine.

sys.dm_xe_sessions (Transact-SQL)

Returns information about an active Extended Events session.

sys.dm_xe_session_targets (Transact-SQL)

Returns information about session targets.

sys.dm_xe_session_events (Transact-SQL)

Returns information about session events.

sys.dm_xe_session_event_actions (Transact-SQL)

Returns information about event session actions.

sys.dm_xe_map_values (Transact-SQL)

Provides a mapping of internal numeric keys to human-readable text.

sys.dm_xe_session_object_columns (Transact-SQL)

Shows the configuration values for objects that are bound to a session.

Use the following system tables to obtain information about the Extended Events equivalents for SQL Trace event classes and columns.

Name

Description

trace_xe_event_map (Transact-SQL)

Contains one row for each Extended Events event that is mapped to a SQL Trace event class.

trace_xe_action_map (Transact-SQL)

Contains one row for each Extended Events action that is mapped to a SQL Trace column ID.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.