Home » Microsoft » 70-473 v.2 » Which two tools can you use to identify the longest running queries?
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 Diagnostics for the virtual machine
Correct Answer: AB
Explanation/Reference:
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
