DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ48

Monitor, configure, and optimize database resources

You have an Azure SQL database named db1 on a server named server1.

The Intelligent Insights diagnostics log indicates that queries are causing performance problems because of tempDB contention.

You need to remediate the performance problems.

What should you do?

Explanation

Memory-optimized tables can replace temporary-table workloads and avoid tempdb utilization, reducing the concurrent access bottleneck that causes tempdb contention. Microsoft’s Intelligent Insights troubleshooting guidance specifically recommends using memory-optimized tables to alleviate this condition.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!