trace_xe_action_map (Transact-SQL)


Updated: June 10, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains one row for each Extended Events action that is mapped to a SQL Trace column ID. This table is stored in the master database, in the sys schema.

Column nameData typeDescription
trace_column_idsmallintThe ID of the SQL Trace column that is being mapped.
package_namenvarchar(60)The name of the Extended Events package where the mapped action resides.
xe_action_namenvarchar(60)The name of the Extended Events action that is mapped to the SQL Trace column.

You can use the following query to identify the Extended Events actions that are equivalent to the SQL Trace columns:

SELECT AS trace_column, am.package_name, am.xe_action_name  
FROM sys.trace_columns AS tc  
INNER JOIN sys.trace_xe_action_map AS am  
   ON tc.trace_column_id = am.trace_column_id  

SQL Trace columns that do not map to actions are not included in the table.

trace_xe_event_map (Transact-SQL)

Community Additions