Which two tools can you use to identify the longest running queries?

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

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.