0 out of 1 rated this helpful - Rate this topic

sys.dm_xe_session_targets (Transact-SQL)

SQL Server 2012

Returns information about session targets.

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.

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions