You have Microsoft SQL Server 2014 installed on a Microsoft Azure virtual machine.

One of the databases on the virtual machine supports a highly active Online Transaction Pr

ocessing (OLTP) application. Users report abnormally long wait times when they submit data in the application.

Which two tools can you use to identify the longest running queries? Each correct answer presents a complete solution.

A. the Job Activity Moni

tor

B. Database Engine Tuning Advisor

C. dynamic management views

D. SQL Server Extended Events

E. SQL metrics in Azure Diagnostics for the virtual machine

Explanation:

C: Microsoft Azure SQL Database enables a subset of dynamic management

views to diagnose performance problems, which might be caused by blocked or long-running queries, resource bottlenecks, poor query plans, and so on. You can detect such common performance problems by using dynamic management views.

D: The SQL Profiler has

been replaced by SQL Server Extended Events.

Extended Events works via Event Tracing (ETW). This has been the common way for all Microsoft related technologies to expose diagnostic data.

ETW provides much more flexibility.

Reference:

https://docs.micros

oft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs

Performance Tuning in SQL Server Tutorial: Top 5 Ways to Find Slow Queries