In may the engineering team for Azure SQL Data Warehouse announced integration with SQL Operations Studio. Now they have released a preview of an extension that contains pre built dashboards to monitor you Data Warehouse instances! Today you can monitor data skew, ColumnStore index health, and system resource usage. We expect more scenarios to be added over time so check back!
To get started:
• Download SQL Operations Studio
• Access Extensions Manager and install ‘Azure SQL Data Warehouse Insights’
• Click reload and Connect to SQL DW server.
• Right click on server and click ‘Manage.’ Click on DW Tab to see your insights!
Be sure to provide your feedback!