If a report is taking an unusually long time to render, which DMV provides real-time information about active requests that can help diagnose the issue?

If a report is taking an unusually long time to render, which DMV provides real-time information about active requests that can help diagnose the issue?

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

Answer: (A)

Real-time visibility into what is currently executing on the server. sys.dm_exec_requests lists every active request, showing its status, wait type, blocking information, CPU time, reads/writes, and elapsed time. This makes it the best tool when a report is slow because you can see exactly which query is running, whether it’s waiting on a resource, or being blocked, and by which session. You can also easily bring in the exact SQL text and execution plan for deeper diagnosis. The other DMVs serve different purposes: sys.dm_exec_queries_stats provides historical, cached query performance statistics rather than live activity; sys.dm_exec_connections focuses on connection properties rather than the execution state; and sys.dm_exec_sessions gives session metadata but not the current execution/wait state.

Real-time visibility into what is currently executing on the server. sys.dm_exec_requests lists every active request, showing its status, wait type, blocking information, CPU time, reads/writes, and elapsed time. This makes it the best tool when a report is slow because you can see exactly which query is running, whether it’s waiting on a resource, or being blocked, and by which session. You can also easily bring in the exact SQL text and execution plan for deeper diagnosis.

The other DMVs serve different purposes: sys.dm_exec_queries_stats provides historical, cached query performance statistics rather than live activity; sys.dm_exec_connections focuses on connection properties rather than the execution state; and sys.dm_exec_sessions gives session metadata but not the current execution/wait state.