Review Questions

  1. You are a database administrator responsible for maintaining a SQL Server 2005 instance. You get a call from the corporate help desk saying that database users are complaining about poor query performance. You need to see what queries are currently consuming the most SQL Server 2005 resources. What do you do?

    1. Use SQL Server Profiler using the Tuning template.
    2. Use SQL Server Profiler using the TSQL_Duration template.
    3. Query the sys.dm_exec_query_stats DMV.
    4. Query the sys.dm_exec_query_plan DMV.
  2. You are the database administrator for you company. Marion, a junior developer, has asked you to tune a store procedure. The stored procedure reads a [Products] table four times to calculate four different reports. The problem is that ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.