Exam DP-300 topic 3 question 34 discussion

I believe D is right based on https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs#identify-tempdb-performance-issues

This is the trick. "whether the performance issue relates to the use of tempdb"! therefore, we need to look at the trend. Option C is the right answer.

So below link suggests that we should simply check sys.dm_exec_requests (wait_type, wait_resource) DMV to see if current queries experiencing PAGELATCH_ waits with tempdb resource. Also instead of writing our own queries that check for that, simply use sp_WhoIsActive which shows running requests in convenient format. https://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs?view=azuresql#identify-tempdb-performance-issues

the question is simple: identify IF tempdb is the issue. https://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance?view=azuresql - "TempDB contention What is happening This detectable performance pattern indicates a database performance condition in which a bottleneck of threads trying to access tempdb resources exists. (This condition isn't IO-related.) The typical scenario for this performance issue is hundreds of concurrent queries that all create, use, and then drop small tempdb tables. The system detected that the number of concurrent queries using the same tempdb tables increased with sufficient statistical significance to affect database performance compared to the past seven-day performance baseline." So it it the Insight, not DMVs.

Right answer is D as per link: https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs?view=azuresql#identify-tempdb-performance-issues

Troubleshoot Azure SQL Database and Azure SQL Managed Instance performance issues with Intelligent Insights

(1) Option C is the right answer. It is a trick. Troubleshoot Azure SQL Database and Azure SQL Managed Instance performance issues with Intelligent Insights https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance?view=azuresql (2) D is only for identifying IO performance issues.

Answer is correct. https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance

D is right based on https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs#identify-tempdb-performance-issues

Correct answer is D

use dmv for tempdb issues

for tempdb = D

C is correct.

C is correct. If you check the link provided it reads that tempdb contention is monitored and reported through Intelligent Insights.

For me, D is the correct answer as well.

Answer is A: Query store can provide details on TempDB usage by queries.

D is correct, but the links provided do not provide the actual DMV queries needed.