You are analyzing the performance of a SQL Azure database. You need to recommend an approach for identifying the indexes that should be added to improve database performance. What should you…

Question

Options

• AUse SQL Server Profiler to identify missing indexes.
• BUse the Database Engine Tuning Advisor to identify missing indexes.
• CUse a Dynamic Management View to analyze query plans.
• DUse a Dynamic Management View to ascertain the number of pending I/O requests.

• A
  2% (1)
• B
  6% (3)
• C
  83% (39)
• D
  9% (4)

Explanation

Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. There are two types of dynamic management views and functions: Server-scoped dynamic management views and functions. These require VIEW SERVER STATE permission on the server. Database-scoped dynamic management views and functions. These require VIEW DATABASE STATE permission on the database.

No community discussion yet for this question.