Azure SQL Virtual Machines Reimagined: Sizing (Ep.1) | Data Exposed Live

Typically, you choose a VM when your application requires more control over the computing environment than the other platform-as-a-service options offer. This can be due to vendor requirements, familiarity with virtualization, ease of migration and other scenarios. When selecting a virtual machine to host your SQL Server workload in Azure, you need to choose a virtual machine size that provides optimal performance and fits your organization’s budget. In this session with Pam Lahoud and David Pless, we will cover topics such as the different virtual machine types that are most appropriate for SQL Server workloads, optimal memory-to-core ratios for various workload types, and features unique to Azure such as write acceleration that can help boost your performance without breaking the bank. We will also cover the Azure Virtual Machine naming conventions and how you can quickly identify the capabilities of a given machine from the virtual machine series name. We will close out the discussion with a review of virtual machine disks and storage limits that will be a precursor to the next deep dive on Azure SQL VM storage. 0:00 Show starts 0:23 Introduction 1:00 Speaker Intros 2:13 SQL Server on-prem vs SQL Server running on Azure VM 6:30 Performance Guidance for SQL Server 8:15 Azure compute options 12:40 Naming convention explanation 14:22 Optimize SQL Server license cost with constrained vCPU VMs 20:38 Recommended SQL VM Memory Optimized Series 23:40 Demo: Sizing Insights from the Azure Portal 27:36 Preferred Azure SQL Virtual Machine storage 30:50 Workload performance indicators 32:22 Counters to measure app perf requirements 34:02 Storage Spaces Overview 41:24 Azure SQL VM Caching and Storage Throttling 46:25 Host VM Caching 54:15 Best Practices ✔️ Resources: SQL Server on Azure VM:    • SQL Server on Azure VM Overview | Azu...   Performance guidelines for SQL Server on Azure Virtual Machines: aka.ms/sqlvm-perf M-series: docs.microsoft.com/en-us/azure/virtual-machines/m-… What disk types are available in Azure?: docs.microsoft.com/en-us/azure/virtual-machines/di… Azure SQL Virtual Machine Reimagined Series: aka.ms/azuresqlvmyt 📌 Let's connect: Twitter: David Pless, twitter.com/dpless Twitter: Pam Lahoud, twitter.com/SQLGoddess Twitter: Anna Hoffman, twitter.com/AnalyticAnna​​ Twitter: AzureSQL, aka.ms/azuresqltw​​ 🔴 To check out even more Data Exposed Live episodes, see our playlist: aka.ms/dataexposedlive​​ 🔔 Subscribe to our channels for even more SQL tips: aka.ms/msazuresqlyt​​ #AzureSQL​​ #AzureSQLVM #AzureSQLVirtualMachine

• #science_technology
• #microsoft
• #developers
• #azure_sql
• #azure_sql_virtual_machines
• #azure_sql_vm