TechNet
Export (0) Print
Expand All

sys.server_event_session_fields (Transact-SQL)

 

Returns a row for each customizable column that was explicitly set on events and targets.

Applies to: SQL Server (SQL Server 2008 through current version).
Column nameData typeDescription
event_session_idintThe ID of the event session. Is not nullable.
object_idintThe ID of the object this field is associated with. Is not nullable.
namesysnameThe name of the field. Is not nullable.
valuesql_variantThe value of the field. Is not nullable.

Requires VIEW SERVER STATE permission on the server.

This view has the following relationship cardinalities.

FromToRelationship
sys.server_event_session_actions.event_session_idsys.server_event_sessions.event_session_idMany 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

Community Additions

ADD
Show:
© 2016 Microsoft