Wouldn't it be great if there was a way to learn if your SQL Server on Azure Virtual Machines was configured optimally? Do you have the right options set? Do you have your tempdb on the right disk? Can your queries perform better? All these and more can be answered using the new Azure portal experience on the SQL virtual machine resource page on Data Exposed with Ebru Ersan and Anna Hoffman.
SQL Assessment feature, once enabled, will evaluate your SQL Server on Azure VM against configuration best practices to determine if your system is healthy and setup for success. This feature is currently in preview.
Resources:
SQL Assessment for SQL Server on Azure VMs (Preview): https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-assessment-for-sql-vm
Preview: SQL Assessment for SQL Server on Azure Virtual Machines:
https://techcommunity.microsoft.com/t5/sql-server-blog/preview-sql-assessment-for-sql-server-on-azur...
Azure SQL Virtual Machine Reimagined Series: https://aka.ms/azuresqlvmyt
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.