sys.pdw_diag_sessions (Transact-SQL)

Applies to: Analytics Platform System (PDW)

Holds information regarding the various diagnostic sessions that have been created on the system.

Column Name	Data Type	Description
name	nvarchar(255)	Name of the diagnostics session. Key for this view.
xml_data	nvarchar(4000)	XML payload describing the session.
is_active	bit	Flag indicating whether the flag is active.
host_address	nvarchar(255)	Address of the machine hosting the session definition (Control node).
principal_id	int	ID of the user that created the session at the database level.
database_id	int	ID of the database that is the scope of the diagnostic session.

See Also