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
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.
https://www.sqlshack.com/sql-server-performance-monitoring-data-collector/