1.SSMS

 

1         SSMS\Management  1.1         Policy Management 1.2         Data Collection 1.3         Resource Governor 1.4         Extended Events 1.4.1        Sessions -          sys.dm_xe_sessions -          Default 3 sessions available.  We can create new sessions by using template or our own. -          To know the running status of extended events use the query SELECT            ES.name,            iif(RS.name IS NULL, 0, 1) AS running FROM sys.dm_xe_sessions RS RIGHT JOIN sys.server_event_sessions ES ON RS.name = ES.name --WHERE es.name = '<YOUR XE SESSION NAME>'