Skip to content

sys-database-event-session-targets-azure-sql-database.md

Latest commit

 

History

History
50 lines (40 loc) · 3.05 KB

sys-database-event-session-targets-azure-sql-database.md

File metadata and controls

50 lines (40 loc) · 3.05 KB
title sys.database_event_session_targets
description The sys.database_event_session_targets dynamic management view (DMV) returns a row for each event target for a database-scoped event session.
author rwestMSFT
ms.author randolphwest
ms.date 07/29/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
ms.custom
ignite-2025
dev_langs
TSQL
monikerRange =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

sys.database_event_session_targets

[!INCLUDE sqlserver2016-asdb-asdbmi-fabricsqldb]

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.

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