| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
trace_xe_action_map (Transact-SQL) |
Extended Events Tables - trace_xe_action_map |
VanMSFT |
vanto |
06/10/2016 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
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 name | Data type | Description |
|---|---|---|
| trace_column_id | smallint | The ID of the SQL Trace column that is being mapped. |
| package_name | nvarchar(60) | The name of the Extended Events package where the mapped action resides. |
| xe_action_name | nvarchar(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 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.