Question

You have a server that runs SQL Server 2016 Standard Edition. You need to examine the missing indexes. What should you use?

A. Activity Monitor
B. Query Store
C. SQL Server Data Collector
D. SQL Server Data Tools

Answer 1

To examine the missing indexes in SQL Server 2016 Standard Edition, you should use Query Store. Query Store captures query performance data and helps identify queries that can benefit from additional indexes.

Step-by-step explanation:

To examine the missing indexes in SQL Server 2016 Standard Edition, you should use Query Store. Query Store is a feature in SQL Server that captures query performance data and provides insights into query execution statistics, including the missing indexes.

By enabling Query Store, you can analyze the execution plans and identify queries that can benefit from additional indexes. It allows you to track the performance of queries over time and optimize the indexing strategy to improve query performance.

For example, you can use the Query Store reports to identify the top queries with the highest missing index impact and then create those missing indexes to enhance the database's performance.