2 minutes to read
In this article
THIS TOPIC APPLIES TO: SQL Server (starting with 2008) Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse
Returns information about session targets.
varbinary(8) The memory address of the event session. Has a many-to-one relationship with sys.dm_xe_sessions.address. Is not nullable.
nvarchar(60) The name of the target within a session. Is not nullable.
uniqueidentifier The GUID of the package that contains the target. Is not nullable.
bigint The number of times the target has been executed for the session. Is not nullable.
bigint The total amount of time, in milliseconds, that the target has been executing. Is not nullable.
nvarchar(max) The data that the target maintains, such as event aggregation information. Is nullable.
Requires VIEW SERVER STATE permission on the server.
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.
Dynamic Management Views and Functions (Transact-SQL)