Dynamic Management Views Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Performance Monitoring

What you'll be asked

  1. Which prefix is used to identify Dynamic Management Views (DMVs) in SQL Server?
  2. You need to identify the most resource-intensive queries currently in the plan cache. Which DMV should you query?
  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. If you want to determine if your database is experiencing memory pressure by looking at buffer pool usage, which DMV is most appropriate?
  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?

Answers and explanations come after you submit.