Which dynamic management view provides details about SQL commands running in the data warehouse?

Which dynamic management view provides details about SQL commands running in the data warehouse?

• A. sys.dm_exec_connections
• B. sys.dm_exec_sessions
• C. sys.dm_exec_query_stats
• D. sys.dm_exec_requests

Answer: (D)

Monitoring currently executing work is what this question is about. To see the SQL commands that are running right now in the data warehouse, you use the dynamic management view that lists each in-flight request. It shows per-request details such as session, status, start time, and the type of command being executed. Importantly, you can combine it with the SQL text of the running statement to see the exact query, by querying the view and cross applying the function that returns the SQL text from the request’s sql_handle. This lets you identify exactly what is being executed, which is crucial for diagnosing long-running queries, blocking, or ETL steps that are still in progress. The other views focus on different aspects: connections, or sessions, or performance statistics of cached queries. They don’t provide the live running SQL commands for active requests, so they don’t give the same real-time view of what is currently executing.

Monitoring currently executing work is what this question is about. To see the SQL commands that are running right now in the data warehouse, you use the dynamic management view that lists each in-flight request. It shows per-request details such as session, status, start time, and the type of command being executed. Importantly, you can combine it with the SQL text of the running statement to see the exact query, by querying the view and cross applying the function that returns the SQL text from the request’s sql_handle. This lets you identify exactly what is being executed, which is crucial for diagnosing long-running queries, blocking, or ETL steps that are still in progress.

The other views focus on different aspects: connections, or sessions, or performance statistics of cached queries. They don’t provide the live running SQL commands for active requests, so they don’t give the same real-time view of what is currently executing.