You have Microsoft SQL Server installed on

a Microsoft Azure virtual machine.

One of the databases on the virtual machine supports a highly active Online Transaction Processing (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. Dynamic management views

B. SQL Server Extended Events

C. Database Engine Tuning Advisor

D. the Job Activity Monitor

E. SQL metrics in Azure Diagnost

ics for the virtual machine

Explanation:

A: 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.

B: 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.microsoft.com/en-us/azure/sql-database/sql-database-monitoring-with-dmvs

https://stackify.com/performance-tuning-in-sql-server-find-slow-

queries