Additional workload insights for advanced performance tuning with SQL Data Warehouse
Posted on Monday, November 12, 2018
Azure SQL Data Warehouse provides a built-in holistic management experience by having a tight integration within the Microsoft Azure ecosystem, specifically Azure Advisor and Azure Monitor. These two services are immediately configured by default for SQL Data Warehouse to automatically deliver you workload insights at no additional cost. We have now enhanced this experience.
In this release, there are additional performance recommendations through Azure Advisor at your disposal, including:
- Adaptive cache: Be advised when to scale to optimize cache utilization.
- Table distribution: Determine when to replicate tables to reduce data movement and increase workload performance.
- Tempdb: Understand when to scale and configure resource classes to reduce tempdb contention.