There is a new preview release of Index Advisor for SQL Azure V12 databases. It can analyze the historical performance data and can recommend on the best suited Index (non-clustered indexes only) to improve the query performance.
Currently, it’s doable only from the new portal – https://portal.azure.com/.
Here is how it looks:
1.Sign in to the Azure Portal.
2.Click BROWSE in the left menu.
3.Click SQL databases in the Browse blade.
4.On the SQL databases blade, click the database that you want to review recommended indexes for.
5.Click Index Advisor to open and view the available Index recommendations for the selected database.
Once you sign up, the portal looks like :
For more information , please check – https://azure.microsoft.com/en-us/documentation/articles/sql-database-index-advisor/
HTH!
[…] Advisor as discussed in my previous post – https://dbcouncil.net/2015/07/07/sql-database-index-advisor-v12-sql-azure-databases/ based on that data. For the upgrade from web and business tier we have a tool called pricing tier […]
LikeLike