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屋!