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 DynamicManagement View to ascertain the number of pending I/O requests.