Your company has a Microsoft SQL Server database hosted on

a Microsoft Azure virtual machine.

You create several reports that display data from the database.

Users report that the reports are slow to display data. You create an index.

You need to identify whether the performance of the reports significantly imp

roves.

A. SQL Server Profiler

B. Query Store

C. Database Engine Tuning Advisor

D. Live Query Statistics

Explanation:

To view the live query execution plan, on the tools menu click the Live Query Statistics icon.

The live query plan displays t

he overall query progress and operator-level run-time execution statistics such as the number of rows produced, elapsed time, operator progress, etc. Because this data is available in real time without needing to wait for the query to complete, these execu

tion statistics are extremely useful for debugging query performance issues.

Incorrect

Answers

:

A: SQL Server Profiler is being discontinued.

B: The SQL Server Query Store feature provides you with insight on query plan choice and performance. It simplifi

es performance troubleshooting by helping you quickly find performance differences caused by query plan changes. Query Store automatically captures a history of

queries, plans, and runtime statistics, and retains these for your review. It separates data by

time windows so you can see database usage patterns and understand when query plan changes happened on the server.

C: Database Engine Tuning Advisor examines how queries are processed in the databases you specify, and then recommends how you can improve q

uery processing performance by modifying database structures such as indexes, indexed views, and partitioning.

References: https://docs.microsoft.com/en-us/sql/relational-databases/performance/live-query-statistics?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/tools/dta/tutorial-database-engine-tuning-advisor?view=sql-server-2017