You have an Azure SQL database named db1 on a server named server1. The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention. You need to…

The correct answer is A. Implement memory-optimized tables. TempDB contention troubleshooting: The diagnostics log outputs tempDB contention details. You can use the information as the starting point for troubleshooting. There are two things you can pursue to alleviate this kind of contention and increase the throughput of the overall…

Submitted by tunde_lagos· Mar 6, 2026Monitor and optimize resources

Question

You have an Azure SQL database named db1 on a server named server1. The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention. You need to resolve the performance issues. What should you do?

Options

AImplement memory-optimized tables.
BRun the dbcc flushprocindB command.
CReplace the sequential index keys with nonsequential keys.
DRun the dbcc dbreindex command.

How the community answered

(48 responses)

A
77% (37)
B
2% (1)
C
15% (7)
D
6% (3)

Explanation

TempDB contention troubleshooting: The diagnostics log outputs tempDB contention details. You can use the information as the starting point for troubleshooting. There are two things you can pursue to alleviate this kind of contention and increase the throughput of the overall workload: You can stop using the temporary tables. You also can use memory- optimized tables. https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot- performance#tempdb-contention

Topics

#tempDB contention#memory-optimized tables#Intelligent Insights#wait statistics

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice