Thursday, January 13, 2022

Azure SQL VM: Optimally Configure SQL Server on Azure Virtual Machines with SQL Assessment (Ep 7)

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-azure-virtual-machines/ba-p/2913466

Azure SQL Virtual Machine Reimagined Series: https://aka.ms/azuresqlvmyt

Posted at https://sl.advdat.com/321jRck