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
The recommendations suggested by Azure Advisor, are based on best practices and usage telemetry in order to be as efficient as possible.
Learn more about Azure SQL Database – Enroll to our Online Course!
Enroll to our online course on Udemy titled “Introduction to Azure SQL Database for Beginners” and get lifetime access to high-quality lessons and hands-on guides about all the aspects of Azure SQL Database.
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).
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.
High Availability Recommendations
The below screenshot, illustrates the 1 recommendation I got regarding High Availability:
If I click on the recommendation, I will get guidance how I can apply it.
Similarly, the below screenshots, illustrates the recommendation summary and actual recommendations I got regarding Security:
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 – Enroll to the Course!
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!
Featured Online Courses
- Boost SQL Server Database Performance with In-Memory OLTP
- Essential SQL Server Administration Tips
- SQL Server Fundamentals – SQL Database for Beginners
- Essential SQL Server Development Tips for SQL Developers
- Introduction to Computer Programming for Beginners
- .NET Programming for Beginners – Windows Forms with C#
- Introduction to Data Science and SQL Server Machine Learning
- Introduction to Azure SQL Database for Beginners
- SQL Server 2019: What’s New – New and Enhanced Features
- Entity Framework: Getting Started – Complete Beginners Guide
- How to Import and Export Data in SQL Server Databases
- Learn How to Install and Start Using SQL Server in 30 Mins
- A Guide on How to Start and Monetize a Successful Blog
- Learn Azure SQL Database: Creating your First Database
- How to Create an Azure SQL Server Virtual Machine
- How to Backup a SQL Server Database from On-Premises to Azure Storage
- … all our Azure-related articles
Subscribe to our newsletter and stay up to date!
Subscribe to our YouTube channel (SQLNetHub TV)
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.
Benchmark SQL Server memory-optimized tables with In-Memory OLTP Simulator.
Rate this article:
Reference: SQLNetHub.com (https://www.sqlnethub.com)
© 2018 SQLNetHub
Artemakis Artemiou is a Senior SQL Server Architect, Author, a 9 Times Microsoft Data Platform MVP (2009-2018) and a Udemy Instructor. 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). Moreover, Artemakis teaches on Udemy, you can check his courses here.