SQL Azure数据库-自动调整 [英] SQL Azure Database - Automatic Tuning

问题描述

我一直在使用SQL Azure数据库(单个数据库模型)，并且很少有非常大的表，通常我会在上面运行很少的select和合并查询，这当然很耗时.为了优化情况，我们继续检查了索引和 然后遇到了Azure SQL数据库的功能(即自动调整)，该功能声称启用该功能后，我们可能会显示一些性能建议.

I have been using SQL Azure database (single database model) and have few very large tables on which usually I do run few select and few merge queries which of-course are time consuming. To optimize the situation, we went ahead and checked the indexes and then came across the feature of Azure SQL database i.e. Automatic Tuning which claims that after enabling it, we maybe shown some performance recommendations. 

现在，我在服务器上托管了许多数据库-想要在包含大表的几个数据库上尝试自动调整功能，因此未在服务器级别启用它，但是我们已覆盖设置并在几个数据库上启用了该设置，然后运行很多的 多次查询(包括在查询见解中显示为长期运行的查询)，但是到目前为止我们还没有任何性能建议，因此想了解两件事-

Now, I have number of databases hosted on a server - Wanted to try the automatic tuning feature on few databases containing large tables so did not enable it on server level but we have overridden the setting and enabled it on few databases and ran numerous queries several times (including the ones which are shown as long running queries in query insights too), however we have not got any performance recommendation so far so wanted to understand two things - 

• 在推荐开始出现之后是否有持续时间?
• 我们是否需要使用说明符计划/层来使推荐出现?例如. S1或S4等?
• 是否可能没有任何建议(甚至没有建议)，因此我们看不到数据库的任何建议?如果可以，如何确保?

谢谢.

Bhushan Gawale | RapidCircle

Bhushan Gawale | RapidCircle

推荐答案

Hello,

Azure SQL数据库需要至少监视一天的活动，以便按照说明确定一些建议 此处 .

如果建议当前不可用，则性能建议"页面会显示一条消息，说明原因.

Azure SQL Database needs to monitor activities at least for a day in order to identify some recommendations as explained here.

Automatic tuning is available in all plans.

If recommendations are not currently available, the Performance recommendation page provides a message explaining why.

希望这样做帮助.

问候

Regards,

Alberto Morillo
SQLCoffee.com

Alberto Morillo
SQLCoffee.com

这篇关于SQL Azure数据库-自动调整的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！