InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 02:49:46 GMT20http://www.sqlservercentral.com/Forums/Topic1412349-392-1.aspxI asked the same question on twitter and got an instant reply from John Sansom (@SqlBrit)The answer is: use sys.server_event_sessions, not sys.dm_xe_sessions.Thanks John,RobbertTue, 29 Jan 2013 02:10:59 GMTRobbert Hofhttp://www.sqlservercentral.com/Forums/Topic1412349-392-1.aspxTo check if an extended event session with a name exists I use the following statement:[code="sql"]SELECT 1 FROM sys.dm_xe_sessions WHERE name = 'exName'[/code]This only returns 1 if the session is started.How can I determine the inactive sessions also?(SQL Server 2008)thanks,RobbertMon, 28 Jan 2013 04:57:30 GMTRobbert Hof