查询性能洞察 [英] Query Performance Insight

问题描述

Azuer门户中的Query Performance Insight中有一个按钮.

There is a button in Azuer portal Query Performance Insight. is it displaying the same thing as Query store ?

推荐答案

按查询存储，您是指查询编辑器吗?对于 Azure SQL数据库查询性能洞察力 管理和调整关系数据库的性能是一项艰巨的任务，需要大量的专业知识和时间投入. Query Performance Insight通过提供以下功能，使您可以花费更少的时间对数据库性能进行故障排除:

Managing and tuning the performance of relational databases is a challenging task that requires significant expertise and time investment. Query Performance Insight allows you to spend less time troubleshooting database performance by providing the following:

• 更深入地了解您的数据库资源(DTU)消耗.
• 按CPU/持续时间/执行次数统计的头条查询，可以对其进行调整以提高性能.
• 该功能来深入查询的详细信息，查看其文本和资源利用的历史记录.
• 性能调优批注显示了

• Deeper insight into your databases resource (DTU) consumption.
• The top queries by CPU/Duration/Execution count, which can potentially be tuned for improved performance.
• The ability to drill down into the details of a query, view its text and history of resource utilization.
• Performance tuning annotations that show actions performed by SQL Azure Database Advisor

查询编辑器只是一个接口，您无需连接SSMS客户端即可对Azure SQL实例进行连接和运行T-SQL.

The Query Editor is simply an interface for your to connect and run T-SQL against your Azure SQL Instance without the need to connect with the SSMS client.

此致

迈克

这篇关于查询性能洞察的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！