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
Last activity: May 14, 2025, 07:04 PM