What should you do?

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?
A . Implement memory-optimized tables.
B. Run the dbcc flushprocindB command.
C. Replace the sequential index keys with nonsequential keys.
D. Run the dbcc dbreindex command.

View Answer

Answer: A

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance#tempdb-contention