You can evaluate your SQL Server on Azure VM for configuration best practices using SQL best practices assessment feature on Azure portal. GA announcement post explains how to use this feature using Azure portal. In this post, we’ll talk about how to enable and configure this feature, and start assessment runs at scale.
If you have more than a handful of SQL Servers on Azure VMs, you probably want to automate both the one-time operations like enabling and configuring the feature, as well as recurring operations like starting assessment runs. Ideally you run a script to enable the feature,