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 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.
the Job Activity Monitor
B.
Database Engine Tuning Advisor
C.
dynamic management views
D.
SQL Server Extended Events
E.
SQL metrics in Azure Diagnostics for the virtual machine