What should you do?

You administer a Microsoft SQL Server 2016 server.

You plan to deploy new features to an application.

You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.

What should you do?
A . Query the sys.dm_db_index_usage_stats DM
C . Query the sys.dm_db_missing_index_details DM
E . Use the Database Engine Tuning Advisor.
F . Query the sys.dm_db_missing_index_columns DM

View Answer

Answer: C

Explanation:

The Microsoft Database Engine Tuning Advisor (DTA) analyzes databases and makes recommendations that you can use to optimize query performance. You can use the Database Engine Tuning Advisor to select and create an optimal set of indexes, indexed views, or table partitions without having an expert understanding of the database structure or the internals of SQL Server. Using the DTA, you can perform the following tasks.

Troubleshoot the performance of a specific problem query

Tune a large set of queries across one or more databases

Perform an exploratory what-if analysis of potential physical design changes

Manage storage space

References: https://docs.microsoft.com/en-us/sql/relational-databases/performance/database-engine-tuningadvisor