Dynamic Management Views Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Performance Monitoring

Dynamic Management Views Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    Which prefix is used to identify Dynamic Management Views (DMVs) in SQL Server?

  2. 2

    You need to identify the most resource-intensive queries currently in the plan cache. Which DMV should you query?

  3. 3

    Which DMV would you use to troubleshoot current blocking issues by identifying which session is holding a lock that others are waiting for?

  4. 4

    If you want to determine if your database is experiencing memory pressure by looking at buffer pool usage, which DMV is most appropriate?

  5. 5

    You are analyzing a query plan and need to correlate a 'plan_handle' from sys.dm_exec_query_stats to the actual T-SQL text. Which function must you use in conjunction with the DMV?