Sample Header Ad - 728x90

How can I determine the state of an Extended Events session (started or stopped) in Azure SQL Database?

2 votes
1 answer
98 views
How can I determine the state of an Extended Events session (started or stopped) in Azure SQL Database? The DMV sys.dm_xe_database_sessions doesn't have this information, and none of the other sys.dm_xe_* DMVs seem to have an appropriate column. I want to do something like this to get a list of the sessions and the state of each for the current database:
SELECT s.[name], x.???
FROM sys.dm_xe_database_sessions s 
JOIN sys.dm_xe_??? x ON s.[name] = x.[name]
Asked by Mark Freeman (2293 rep)
May 14, 2025, 04:56 PM
Last activity: May 14, 2025, 07:04 PM