Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
trace_xe_action_map (Transact-SQL)
Collapse the table of content
Expand the table of content

trace_xe_action_map (Transact-SQL)


Applies To: SQL Server 2014, SQL Server 2016 Preview

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.

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

Column name

Data type




The ID of the SQL Trace column that is being mapped.



The name of the Extended Events package where the mapped action resides.



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 tc.name 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.

Community Additions

© 2015 Microsoft