Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todaysys.server_event_session_fields (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Managed Instance
Returns a row for each customizable column that was explicitly set on events and targets.
| Column name | Data type | Description |
|---|---|---|
| event_session_id | int | The ID of the event session. Is not nullable. |
| object_id | int | The ID of the object this field is associated with. Is not nullable. |
| name | sysname | The name of the field. Is not nullable. |
| value | sql_variant | The value of the field. Is not nullable. |
Requires VIEW SERVER STATE permission on the server.
This view has the following relationship cardinalities.
| From | To | Relationship |
|---|---|---|
| sys.server_event_session_actions.event_session_id | sys.server_event_sessions.event_session_id | Many to one |
| sys.server_event_session_actions.event_id sys.server_event_session_actions.object_id sys.server_event_session_actions.event_session_id |
sys.server_event_session_events.event_session_id sys.server_event_session_events.event_id |
Many to one |
| sys.server_event_session_actions.event_session_id sys.server_event_session_actions.object_id |
sys.server_event_session_targets.event_session_id sys.server_event_session_targets.target_id |
Many to one |
Catalog Views (Transact-SQL)
Extended Events Catalog Views (Transact-SQL)
Extended Events