DP-300 Certification Practice Question #139

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 by Azure SQL databases in sqlsrv1.
What should you do?

Accepted Answer

The MS Learn article "Monitor performance using dynamic management views" contains an explicit section titled "Identify tempdb performance issues" which uses DMVs such as `sys.dm_exec_requests` (checking `wait_resource` starting with `2:x:y` for tempdb database ID 2) to diagnose tempdb contention — this is the authoritative, direct match to the question. Query Performance Insight (C) only surfaces CPU, Data IO, Log IO, Duration, and Execution count — it has no tempdb-specific visibility. While Intelligent Insights does detect TempDB contention, it is not an option in this question. DMV queries are the standard tool for identifying tempdb-related wait types (PAGELATCH_*).

More DP-300 practice questions