You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases. The databases perform slower than expected. You need to identify whether the performance issue relates to the…

The correct answer is D. Run dynamic management view-based queries. The diagnostics log outputs tempDB contention details. You can use the information as the starting point for troubleshooting. You can use the Intelligent Insights performance diagnostics log of Azure SQL Database to troubleshoot performance issues…

Submitted by layla.eg· Mar 6, 2026Monitor, configure, and optimize database resources

Question

You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases. The databases perform slower than expected. You need to identify whether the performance issue relates to the use of tempdb on sqlsrv1. What should you do?

Options

ARun Query Store-based queries
BReview information provided by SQL Server Profiler-based traces
CReview information provided by Query Performance Insight
DRun dynamic management view-based queries

How the community answered

(28 responses)

A
14% (4)
B
4% (1)
C
7% (2)
D
75% (21)

Explanation

The diagnostics log outputs tempDB contention details. You can use the information as the starting point for troubleshooting. You can use the Intelligent Insights performance diagnostics log of Azure SQL Database to troubleshoot performance issues. https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot- performance#tempdb-contention https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-use-diagnostics-log

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice