Export (0) Print
Expand All

sys.dm_xe_session_targets (Transact-SQL)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Returns information about session targets.

Applies to: SQL Server (SQL Server 2008 through current version).

Column name

Data type

Description

event_session_address

varbinary(8)

The memory address of the event session. Has a many-to-one relationship with sys.dm_xe_sessions.address. Is not nullable.

target_name

nvarchar(60)

The name of the target within a session. Is not nullable.

target_package_guid

uniqueidentifier

The GUID of the package that contains the target. Is not nullable.

execution_count

bigint

The number of times the target has been executed for the session. Is not nullable.

execution_duration_ms

bigint

The total amount of time, in milliseconds, that the target has been executing. Is not nullable.

target_data

nvarchar(max)

The data that the target maintains, such as event aggregation information. Is nullable.

Requires VIEW SERVER STATE permission on the server.

Relationship Cardinalities

From

To

Relationship

sys.dm_xe_session_targets.event_session_address

sys.dm_xe_sessions.address

Many-to-one

Updated content

Corrected the data type for the target_data column.

Corrected the description for the target_data column to indicate that the value is nullable.

Corrected the "Relationship Cardinalities" table.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft