What should you use?

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.

You have an on-premises server that runs Microsoft SQL Server 2016 Standard Edition.

You need to identify missing indexes.

What should you use?
A . Activity Monitor
B . Sp_who3
C . SQL Server Management Studio (SSMS) Object Explorer
D . SQL Server Data Collector
E . SQL Server Data Tools (SSDT)
F . SQL Server Configuration Manager

View Answer

Answer: D

Explanation:

Data Collector can gather performance information from multiple SQL Server instances and store it in a single repository. It has three built-in data collecting specifications (data collectors) designed to collect the most important performance metrics. The information collected by default is about disk usage, query statistics, and server activity. The Query Statistics data collection set collects information about query statistics, activity, execution plans and text on the SQL Server instance. Missing indexes can be found with the execution plans.

References: https://www.sqlshack.com/sql-server-performance-monitoring-data-collector/