Microsoft
DP-300 · Question #166
You have an Azure SQL Database managed instance. The instance starts experiencing performance issues. You need to identify which query is causing the issue and retrieve the execution plan for the…
The correct answer is D. dynamic management views. Use the dynamic management view sys.dm_exec_requests to track currently executing queries and the associated worker time. Not C: DMVs that track Query Store and wait statistics show results for only successfully completed and timed-out queries…
Submitted by obi.ng· Mar 6, 2026Monitor, configure, and optimize database resources
Question
You have an Azure SQL Database managed instance. The instance starts experiencing performance issues. You need to identify which query is causing the issue and retrieve the execution plan for the query. The solution must minimize administrative effort. What should you use?
Options
- Athe Azure portal
- BExtended Events
- CQuery Store
- Ddynamic management views
How the community answered
(37 responses)- A14% (5)
- B5% (2)
- C3% (1)
- D78% (29)
Explanation
Use the dynamic management view sys.dm_exec_requests to track currently executing queries and the associated worker time. Not C: DMVs that track Query Store and wait statistics show results for only successfully completed and timed-out queries. https://docs.microsoft.com/en-us/azure/azure-sql/identify-query-performance-issues
Community Discussion
No community discussion yet for this question.