使用 Azure 顾问提高 Azure 应用程序的性能Improve performance of Azure applications with Azure Advisor

Azure 顾问性能建议有助于提高关键业务应用程序的速度和响应能力。Azure Advisor performance recommendations help improve the speed and responsiveness of your business-critical applications. 可通过顾问从顾问仪表板的“性能”选项卡获取性能建议。You can get performance recommendations from Advisor on the Performance tab of the Advisor dashboard.

减少流量管理器配置文件上的 DNS 生存时间,可更快地故障转移到正常运行的终结点Reduce DNS time to live on your Traffic Manager profile to fail over to healthy endpoints faster

Azure 顾问将识别配置了较长 TTL 的流量管理器配置文件,并建议将 TTL 配置为 20 秒或 60 秒,具体取决于配置文件是否配置为使用快速故障转移Azure Advisor identifies Traffic Manager profiles with a longer TTL configured and recommends configuring the TTL to either 20 seconds or 60 seconds depending on whether the profile is configured for Fast Failover.

通过 SQL DB 顾问提高数据库性能Improve database performance with SQL DB Advisor

顾问针对所有 Azure 资源提供一个一致且统一的建议视图。Advisor provides you with a consistent, consolidated view of recommendations for all your Azure resources. 它与 SQL 数据库顾问集成,提供建议以改进 SQL Azure 数据库性能。It integrates with SQL Database Advisor to bring you recommendations for improving the performance of your SQL Azure database. SQL 数据库顾问通过分析使用情况历史记录来评估 SQL Azure 数据库的性能。 SQL Database Advisor assesses the performance of your SQL Azure databases by analyzing your usage history. 提供的建议最适合运行数据库典型工作负荷。It then offers recommendations that are best suited for running the database’s typical workload.


若要获取建议,数据库必须具有一周左右的使用量,且该周内必须有一些一致的活动。To get recommendations, a database must have about a week of usage, and within that week there must be some consistent activity. SQL 数据库顾问优化一致的查询模式比优化随机的突发活动更加轻松。SQL Database Advisor can optimize more easily for consistent query patterns than for random bursts of activity.

有关 SQL 数据库顾问的详细信息,请参阅 SQL 数据库顾问For more information about SQL Database Advisor, see SQL Database Advisor.

提高应用服务性能和可靠性Improve App Service performance and reliability

Azure 顾问集成最佳做法建议,可改善应用服务体验,并发现相关平台的功能。Azure Advisor integrates best practices recommendations for improving your App Services experience and discovering relevant platform capabilities. 以下为应用服务建议示例:Examples of App Services recommendations are:

  • 检测其中应用运行时已耗尽内存或 CPU 资源的实例,并提出缓解措施。Detection of instances where memory or CPU resources are exhausted by app runtimes with mitigation options.
  • 检测在其中并置资源(如 Web 应用和数据库)的实例,以改善性能并降低成本。Detection of instances where collocating resources like web apps and databases can improve performance and lower cost.

有关应用服务建议的详细信息,请参阅 Best Practices for Azure App Service(Azure 应用服务的最佳实践)。For more information about App Services recommendations, see Best Practices for Azure App Service.

使用托管磁盘防止磁盘 I/O 限制Use Managed Disks to prevent disk I/O throttling

顾问将识别属于即将达到其可伸缩性目标的存储帐户的虚拟机。Advisor will identify virtual machines that belong to a storage account that is reaching its scalability target. 这种情况使得这些 VM 容易遭受 I/O 限制。This condition makes those VMs susceptible to I/O throttling. 顾问会建议它们使用托管磁盘以防止性能降低。Advisor will recommend that they use Managed Disks to prevent performance degradation.

可以通过使用高级磁盘来提高虚拟机磁盘的性能和可靠性Improve the performance and reliability of virtual machine disks by using Premium Storage

顾问将识别其中的标准磁盘在存储帐户上具有大量事务的虚拟机,并建议升级到高级磁盘。Advisor identifies virtual machines with standard disks that have a high volume of transactions on your storage account and recommends upgrading to premium disks.

Azure 高级存储为运行 I/O 密集型工作负荷的虚拟机提供高性能、低延迟的磁盘支持。Azure Premium Storage delivers high-performance, low-latency disk support for virtual machines that run I/O-intensive workloads. 在固态硬盘 (SSD) 上使用高级存储帐户存储数据的虚拟机磁盘。Virtual machine disks that use premium storage accounts store data on solid-state drives (SSDs). 为使应用程序实现最佳性能,建议将任何需要高 IOPS 的虚拟机磁盘迁移到高级存储。For the best performance for your application, we recommend that you migrated any virtual machine disks requiring high IOPS to premium storage.

删除 SQL 数据仓库表的数据倾斜以提高查询性能Remove data skew on your SQL data warehouse table to increase query performance

运行工作负荷时,数据倾斜可能会造成不必要的数据移动或资源瓶颈。Data skew can cause unnecessary data movement or resource bottlenecks when running your workload. 顾问将检测大于 15% 的分布数据倾斜,并建议重新分布数据和重新访问表分布键选择。Advisor will detect distribution data skew greater than 15% and recommend that you redistribute your data and revisit your table distribution key selections. 若要了解有关识别和删除倾斜的详细信息,请参阅倾斜疑难解答To learn more about identifying and removing skew, see troubleshooting skew.

创建或更新 SQL 数据仓库表的过期表统计信息以提高查询性能Create or update outdated table statistics on your SQL data warehouse table to increase query performance

顾问标识不包含最新表统计信息的表并建议创建或更新表统计信息。Advisor identifies tables that do not have up-to-date table statistics and recommends creating or updating table statistics. SQL 数据仓库查询优化器使用最新统计信息来估计基数或查询结果中的行数,这样一来,查询优化器能够创建高质量的查询计划,以提高性能。The SQL data warehouse query optimizer uses up-to-date statics to estimate the cardinality or number of rows in the query result that enables the query optimizer to create a high-quality query plan for fastest performance.

通过纵向扩展来优化 SQL 数据仓库上的缓存利用率,从而提升查询性能Scale up to optimize cache utilization on your SQL Data Warehouse tables to increase query performance

Azure 顾问会检测 SQL 数据仓库是否具有高缓存使用百分比和低命中百分比。Azure Advisor detects if your SQL Data Warehouse has high cache used percentage and a low hit percentage. 这种情况表示存在高缓存逐出,可能会影响 SQL 数据仓库的性能。This condition indicates high cache eviction, which can impact the performance of your SQL Data Warehouse. 顾问建议你对 SQL 数据仓库进行纵向扩展以确保为工作负荷分配足够的缓存容量。Advisor suggests that you scale up your SQL Data Warehouse to ensure you allocate enough cache capacity for your workload.

将 SQL 数据仓库表转换为复制表以提高查询性能Convert SQL Data Warehouse tables to replicated tables to increase query performance

顾问会识别非复制但是会受益于转换的表,并建议转换这些表。Advisor identifies tables that are not replicated tables but would benefit from converting and suggests that you convert these tables. 建议是基于 SQL 数据仓库表的复制表大小、列数、表分布类型以及分区数提出的。Recommendations are based on the replicated table size, number of columns, table distribution type, and number of partitions of the SQL Data Warehouse table. 还可能会根据上下文在建议中提供额外的启发。Additional heuristics may be provided in the recommendation for context. 若要详细了解此建议是如何确定的,请参阅 SQL 数据仓库建议To learn more about how this recommendation is determined, see SQL Data Warehouse Recommendations.

将存储帐户迁移到 Azure 资源管理器来获取所有最新 Azure 功能。Migrate your Storage Account to Azure Resource Manager to get all of the latest Azure features

将存储帐户部署模型迁移到 Azure 资源管理器(资源管理器)可利用模板部署和更多的安全选项,并可升级到 GPv2 帐户来利用 Azure 存储的最新功能。Migrate your Storage Account deployment model to Azure Resource Manager (Resource Manager) to take advantage of template deployments, additional security options, and the ability to upgrade to a GPv2 account for utilization of Azure Storage's latest features. 顾问将识别使用经典部署模型的任何独立存储帐户,并建议迁移到资源管理器部署模型。Advisor will identify any stand-alone storage accounts that are using the Classic deployment model and recommends migrating to the Resource Manager deployment model.


Azure Monitor 的经典警报计划于 2019 年 6 月停用。Classic alerts in Azure Monitor are scheduled to retire in June 2019. 建议升级经典存储帐户以使用资源管理器在新平台中保留警报功能。We recommended that you upgrade your classic storage account to use Resource Manager to retain alerting functionality with the new platform. 有关详细信息,请参阅经典警报停用For more information, see Classic Alerts Retirement.

如何访问顾问中的性能建议How to access Performance recommendations in Advisor

  1. 登录 Azure 门户,并打开顾问Sign in to the Azure portal, and then open Advisor.

  2. 在顾问仪表板中,单击“性能”选项卡。On the Advisor dashboard, click the Performance tab.

后续步骤Next steps

若要了解有关顾问建议的详细信息,请参阅以下资源:To learn more about Advisor recommendations, see: