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: SQL Data Warehouse Samples - issues.

The following widgets are generated by using T-SQL monitoring scripts embedded within Azure Data Studio. All monitoring scripts are uploaded to the following github: 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.

Copyright (c) Microsoft Corporation. All rights reserved.

Licensed under the Source EULA.