sys.database_event_session_targets

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_targets dynamic management view (DMV) returns a row for each event target for a database-scoped event session. For information about active database-scoped sessions, see sys.dm_xe_database_session_targets.

• 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.
target_id	int	The ID of the target. ID is unique within the event session object. Is not nullable.
name	sysname	The name of the event target. Is not nullable.
package	sysname	The name of the event package that contains the event target. Is not nullable.
module	sysname	The name of the module that contains the event target. Is not nullable.

Permissions

Requires the VIEW DATABASE PERFORMANCE STATE permission.

Remarks

This view has the following relationship cardinalities.

From	To	Relationship
sys.database_event_session_targets.event_session_id	sys.database_event_sessions.event_session_id	Many to one

Related content

• 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_events (Azure SQL Database and Azure SQL Managed Instance)
• Monitoring Microsoft Azure SQL Database and Azure SQL Managed Instance performance using dynamic management views