Explanation/Reference:
Explanation:
- sys.dm_exec_requests
Returns information about each request that is executing within SQL Server.
- sys.dm_exec_sessions
Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a serverscope view that shows information about all active user connections and internal tasks. This information includes client version, client program name, client login time, login user, current session setting, and more.
- sys.dm_exec_query_text
Returns the text of the SQL batch that is identified by the specified sql_handle.
Incorrect Answers:
- sys.dm_exec_query_stats Returns aggregate performance statistics for cached query plans in SQL Server.
The view contains one row per query statement within the cached plan, and the lifetime of the rows are tied to the plan itself.
- sys.objects
Contains a row for each user-defined, schema-scoped object that is created within a database.