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 recommend?
A.
Use SQL Server Profiler to identify missing indexes.
B.
Use the Database Engine Tuning Advisor to identify missing indexes.
C.
Use a Dynamic Management View to analyze query plans.
D.
Use a Dynamic Management View to ascertain the number of pending I/O requests.
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.