You have a report that runs against a Microsoft Azure SQL database.
The report takes more time to return results than expected.
You add an index to a table in the database.
You need to identify whether adding the index improves the performance issue. What should you use?
A.
Database Engine Tuning Advisor
B.
Index Tuning Wizard
C.
Azure Throughput Analyzer
D.
AzureSQL Database Index Advisor
Explanation:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-advisor/