Seamless access to management insights for SQL Data Warehouse with Data Studio
Azure SQL Data Warehouse (SQL DW) is a fast, flexible, and secure analytics platform that helps our customers transform data into actionable insights. Starting today, Azure SQL DW customers can seamlessly get rich insights and build customizable dashboard widgets to better manage and tune their workloads.
This experience is made real by the general availability of Azure Data Studio, a tool that provides a Transact-SQL (T-SQL) code editor with IntelliSense, an integrated terminal for common command line tools, and customizable database widgets encapsulated through extensions. The Azure SQL DW insights extension can be leveraged with Azure Data Studio to automatically render dashboard widgets to help surface tuning insights into your data warehouse. These dashboard views are automatically refreshed to help you seamlessly apply best practices and ensure that your workload is optimized for performance within a single tool.
Currently, the following dashboard widgets are immediately available when downloading the extension.
Data distribution across your data warehouse
You can visualize the data distribution across your data warehouse to immediately detect whether your data warehouse is suffering from physical data skew which can impact query performance.
Table health
These views help you maximize columnstore row group quality, address suboptimal statistics, and resolve data skew. You can also immediately apply your data warehouse recommendations by detecting impacted tables using these views.
Monitor data warehouse activity
You are consistently informed on your data warehouse workload where details on active sessions, queued queries, and loads are automatically refreshed. Also, you can also identify your latest restore point and if required, create a user-defined restore point immediately through the tool’s integrated terminal to ensure your data is protected.
To get started:
- Download SQL Operations Studio
- Access Extensions Manager and install Azure SQL Data Warehouse Insights
- Select Reload and connect to your SQL data warehouse
- Right-click the server and select Manage. Select the Dashboard tab to see your insights
Insight widgets are generated through T-SQL scripts embedded within Azure Data Studio. All monitoring scripts are uploaded to the following GitHub repository: SQL Data Warehouse Samples. You can help improve this extension by contributing or providing feedback.
You can learn more about the Azure SQL DW innovations:
- Read how Azure SQL DW redefines data analytics with the latest service updates
- Read how you can build near real-time analytics solutions with tighter SQL DW and Azure Databricks integration
- Read how user-controlled maintenance windows now give greater control for Azure SQL DW customers
- Read how you continuously monitor your Azure SQL DW workloads with SQL Vulnerability assessment
Source: Azure Blog Feed