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.
  Discussion forum


Leave an answer