Azure SQL Data Warehouse provides recommendations to help ensure that your data warehouse is consistently optimized for performance. Data warehouse recommendations are tightly integrated with Azure Advisor to provide you with best practices directly in the Azure portal. SQL Data Warehouse analyzes the current state of your data warehouse, collects telemetry, and surfaces recommendations for your active workload on a daily cadence. Current supported data warehouse recommendation scenarios are data skew and table statistics.
For more information, see the full blog post. You can also check whether your Gen2 data warehouse has recommendations.