SQL数据库顾问工具与性能建议 [英] SQL database advisor Tool vs performance recommendations

问题描述

在azure门户网站上是同一回事吗?

is it the same thing on azure portal ?

触发推荐的标准是什么?

And what's the criteria to trigger a recommendation ??

例如缺少索引. sys.dm_db_missing_index_groups << I use this dmv, there is records

but in "Performance recommandations, it doesn't show up.

but in "Performance recommandations, it doesn't show up.

有任何触发它的例子吗?

Any example to trigger it?

推荐答案

Hello,

创建了性能建议通过使用人工智能的智能洞察功能实现.

Performance recommendations are created by the Intelligent Insights features which uses artificial intelligence.

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-intelligent-insights

Automatic Tuning which will create indexes needed and drop unneeded indexes is also based on artificial intelligence as explained on below article:

https://azure.microsoft.com/zh-CN/blog/artificial-intelligence-tunes-azure-sql-databases/

https://azure.microsoft.com/en-us/blog/artificial-intelligence-tunes-azure-sql-databases/

希望这会有所帮助.

Hope this helps.

问候

Regards,

Alberto Morillo
SQLCoffee.com

Alberto Morillo
SQLCoffee.com

这篇关于SQL数据库顾问工具与性能建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！