The Azure SQL Data Warehouse insight widget extension provides a pre-built dashboard surfacing insights to your data warehouse. This helps with scenarios around managing and tuning your data warehouse to ensure it is optimized for consistent performance.
For any issues with this extension, please submit them here: Azure Synapse Analytics SQL Pool (formerly SQL Data Warehouse) Samples - issues.
If you have any feedback, please contact: sqldwadvisor@service.microsoft.com.
The following widgets are generated by using T-SQL monitoring scripts embedded within SQL Operations Studio. All monitoring scripts are uploaded to the following github: Azure Synapse Analytics SQL Pool (formerly SQL Data Warehouse) Samples.
Identify and understand workload patterns through active sessions, active queries, queued queries, loads, and backups.
Leverage views to help maximize columnstore row group quality and discover specific tables impacted by suboptimal statistics and data skew.
Detect data skew across distributions to help identify and troubleshoot query performance issues.
Immediately calculate the memory grant required per table to optimally load into SQL Data Warehouse.
Identify your total storage size which includes total database size, unallocated, and reserved space.