Question

Which of the following catalog view is used for SQL Server Extended Events?

(a) sys.server_sessions

(b) sys.server_event_sess

(c) sys.server_event_session_actions

(d) all of the mentioned

I have been asked this question by my school principal while I was bunking the class.

This is a very interesting question from Extended Events in division Monitoring and Auditing of SQL Server

Answer 1

The correct option is (c) sys.server_event_session_actions

To explain I would say: sys.server_event_session_actions returns a row for each action on each event of an event session.