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

From the creator

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. 0:00 Introduction 0:45 SQL Assessment Overview 1:25 Demo 10:38 Getting started ✔️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 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna Twitter: AzureSQL, https://aka.ms/azuresqltw 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL​​​ #AzureSQLVM​ #AzureS

Published 2022-01-13 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.