"The DMVs Worth Knowing"

1. What is the primary purpose of the sys.dm_exec_requests DMV?

To show index usage statistics To show current requests being executed To aggregate query statistics since the last restart To display wait statistics

2. Which DMV provides aggregated data on queries that have been expensive since the last server restart?

sys.dm_exec_requests sys.dm_exec_query_stats sys.dm_os_wait_stats sys.dm_db_index_usage_stats

3. What does a status of 'suspended' in sys.dm_exec_requests indicate?

The query is currently not running The query is waiting on a resource The query has completed execution The query is running successfully

4. Why is the max_grant_kb column important in sys.dm_exec_query_stats?

It shows the number of rows returned by a query It indicates the amount of memory a query is requesting It tracks the execution time of a query It measures CPU time consumed by a query

Continue: "Wait Statistics: What Is It Waiting On?" → Review this lesson Retake quiz