Advanced tuning for Azure SQL Data Warehouse (SQL DW) just got simpler with additional data warehouse recommendations and metrics. SQL DW is a flexible, secure, and fully managed analytics platform for enterprises optimized for running complex queries quickly across petabytes of data.

Often times advanced tuning scenarios with SQL DW can be a challenge without the proper tools to seamlessly uncover performance insights into your data warehouse workload. This can lead to hours of troubleshooting efforts where you must ensure proper monitoring practices are continuously followed. SQL DW provides a built-in holistic management experience by having a tight integration within the Microsoft Azure ecosystem, specifically Azure Advisor and Azure Monitor. These two services are immediately configured by default for SQL Data Warehouse to automatically deliver you workload insights at no additional cost.

There are additional advanced performance recommendations through Azure Advisor at your disposal, including:

Adaptive cache Be advised when to scale to optimize cache utilization. Table distribution Determine when to replicate tables to reduce data movement and increase workload performance. Tempdb Understand when to scale and configure resource classes to reduce tempdb contention.
Automatically discover workload insights for advanced performance tuning directl ...

There is a deeper integration of data warehouse metrics withAzure Monitor including an enhanced customizable monitoring chart for near real-time metrics in the overview blade. You no longer must leave the data warehouse overview blade to access Azure Monitor metrics when monitoring usage, or validating and applying data warehouse recommendations.


Automatically discover workload insights for advanced performance tuning directl ...

There are new metrics available, such as tempdb and adaptive cache utilization to complement your performance recommendations.


Automatically discover workload insights for advanced performance tuning directl ...
Next steps Check if you have Advisor recommendations ! Visit ouronline documentation for more details on recommendations with SQL DW. For feature requests, please vote on our UserVoice . Create an Azure SQL Data Warehouse to get started today. Stay up-to-date on the latest Azure SQL Data Warehouse news and features by following us on Twitter @AzureSQLDW .

本文系统(windows)相关术语:三级网络技术 计算机三级网络技术 网络技术基础 计算机网络技术

代码区博客精选文章
分页:12
转载请注明
本文标题:Automatically discover workload insights for advanced performance tuning directl ...
本站链接:https://www.codesec.net/view/611360.html


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 系统(windows) | 评论(0) | 阅读(60)