Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to:
SQL Server 2016 (13.x) and later
Azure SQL Database
Azure SQL Managed Instance
Returns a row for each customizable column that was explicitly set on events and targets in a database-scoped event session.
Azure SQL Database supports only database-scoped sessions. Azure SQL Managed Instance supports both database-scoped sessions and server-scoped sessions. Server-scoped sessions are recommended for managed instances: learn more in CREATE EVENT SESSION.
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. |
Permissions
Requires the VIEW DATABASE STATE permission.
Remarks
This view has the following relationship cardinalities.
From | To | Relationship |
---|---|---|
sys.database_event_session_actions.event_session_id | sys.database_event_sessions.event_session_id | Many to one |
sys.database_event_session_actions.event_id sys.database_event_session_actions.object_id sys.database_event_session_actions.event_session_id |
sys.database_event_session_events.event_session_id sys.database_event_session_events.event_id |
Many to one |
sys.database_event_session_actions.event_session_id sys.database_event_session_actions.object_id |
sys.database_event_session_targets.event_session_id sys.database_event_session_targets.target_id |
Many to one |
Next steps
Learn more about related concepts in the following articles:
- Extended events in Azure SQL Database
- Event File target code for extended events in Azure SQL Database and SQL Managed Instance
- sys.database_event_sessions (Azure SQL Database and Azure SQL Managed Instance)
- sys.database_event_session_actions (Azure SQL Database and Azure SQL Managed Instance)
- Monitoring Microsoft Azure SQL Database and Azure SQL Managed Instance performance using dynamic management views