नोट
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप साइन इन करने या निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
Applies to:
SQL Server 2016 (13.x) and later versions
Azure SQL Database
Azure SQL Managed Instance
SQL database in Microsoft Fabric
The sys.database_event_session_actions dynamic management view (DMV) returns a row for each action on each event of a database-scoped event session. For information on actions in active database-scoped event sessions, see sys.dm_xe_database_session_event_actions.
- Azure SQL Database and SQL database in Fabric support only database-scoped sessions.
- Azure SQL Managed Instance supports both database-scoped sessions and server-scoped sessions. Server-scoped sessions are recommended for SQL managed instances. For more information, see CREATE EVENT SESSION code examples.
| Column name | Data type | Description |
|---|---|---|
event_session_id |
int | The ID of the event session. Is not nullable. |
event_id |
int | The ID of the event. This ID is unique within the event session object. Is not nullable. |
name |
sysname | The name of the action. Is nullable. |
package |
sysname | The name of the event package that contains the event. Is nullable. |
module |
sysname | The name of the module that contains the event. Is nullable. |
Permissions
Requires the VIEW DATABASE PERFORMANCE 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_idsys.database_event_session_actions.event_session_id |
sys.database_event_session_events.event_session_idsys.database_event_session_events.event_id |
Many to one |