Inactive Extended Event Sessions

• Robbert Hof

  SSCrazy

  Points: 2778

  More actions

  January 28, 2013 at 4:57 am

  #288069

  To check if an extended event session with a name exists I use the following statement:

  SELECT 1 FROM sys.dm_xe_sessions WHERE name = 'exName'

  This only returns 1 if the session is started.

  How can I determine the inactive sessions also?

  (SQL Server 2008)

  thanks,

  Robbert

• Robbert Hof

  SSCrazy

  Points: 2778

  More actions

  January 29, 2013 at 2:10 am

  #1581943

  I 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,

  Robbert