SQL Database Index Advisor – V12 SQL Azure databases

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.

Index_advisor1
Once you sign up, the portal looks like :

portal

For more information , please check – https://azure.microsoft.com/en-us/documentation/articles/sql-database-index-advisor/

HTH!

Advertisements

One thought on “SQL Database Index Advisor – V12 SQL Azure databases

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s