What is Azure Advisor?

What is Azure Advisor?

What is Azure Advisor?

In previous articles, we’ve talked about how you can create your first database in Azure SQL Database, how you can create an Azure SQL Server virtual machine, as well as how to backup a SQL Server database from on-premises to Azure Storage. In this article, we will discuss about what is Azure Advisor and what are exactly the recommendations it suggests.


What is Azure Advisor?

Azure Advisor, is an automated recommendation engine (i.e. a personalized cloud consultant) on Azure, that follows the best practices and provides you with efficient recommendations that fall under the below 4 categories:

  • High Availability
  • Security
  • Performance
  • Cost

The recommendations suggested by Azure Advisor, are based on best practices and usage telemetry in order to be as efficient as possible.


Learn all about Azure SQL Database both Platform as a Service (PaaS) and Infrastructure as a Service (IaaS). Check our online course “Introduction to Azure SQL Database” (lifetime access).


Example of Azure Advisor Recommendations

For example, today when I logged into the Azure Portal, Azure Advisor appeared along with mentioning that I have some free recommendations to check out (see below screenshot).

What is Azure Advisor? - Article on SQLNetHub


After clicking on the “View my free recommendations” button, the actual recommendations page appeared, where I saw that I had 1 recommendation for High Availability and 5 recommendations for Security. Regarding Performance and Cost, at the that time, I had no recommendations.

What is Azure Advisor? - Article on SQLNetHub


High Availability Recommendations

The below screenshot, illustrates the 1 recommendation I got regarding High Availability:

What is Azure Advisor? - Article on SQLNetHub

If I click on the recommendation, I will get guidance how I can apply it.


Security Recommendations

Similarly, the below screenshots, illustrates the recommendation summary and actual recommendations I got regarding Security:

What is Azure Advisor? - Article on SQLNetHub


What is Azure Advisor? - Article on SQLNetHub

When further clicking on the above recommendations, you get guidance on how to easily apply them and mitigate any detected security issues.



Azure Advisor, is a very useful entity in Microsoft Azure, It analyzes your Azure resource configuration and usage telemetry, and suggests useful recommendations on how to tackle different potential issues.

Azure Advisor may appear from time to time right after you log into Azure Portal, along with suggesting fresh, useful recommendations, or you can launch it at any time, from within Azure Portal – All Services (type ‘Advisor’).

Learn more about Azure Advisor.


See More!

Learn more about Azure SQL Database and get started fast and easy! Through our online course, you will get lifetime access to a comprehensive set of lectures and live demonstrations that will get you started with Azure SQL Database in no time! The course is regularly updated with additional educational material!

Enroll Now with Discount!


Introduction to Azure SQL Database (Online Course - Lifetime Access)

Introduction to Azure SQL Database (Online Course – Lifetime Access)


Read Also


Check our latest software releases!

Easily generate SQL code snippets with Snippets Generator!

Convert static T-SQL to dynamic and vice versa with Dynamic SQL Generator.

Secure your SQL Server instances with DBA Security Advisor.


Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)


Reference: SQLNetHub.com (https://www.sqlnethub.com)

© 2018 SQLNetHub


What is Azure Advisor? Click to Tweet
Artemakis Artemiou
Artemakis Artemiou is a Senior SQL Server Architect, Author, and a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Artemakis's official website can be found at aartemiou.com.