Looking to migrate workloads to Azure? Azure SQL VMs are a great place to start. We have the same full version of SQL Server that we know and love that we’ve been using on-premises. When migrating to an Azure VM, there are certain needs to take into consideration when sizing the VM. Azure VMs come in various types and sizes. The types help narrow down the general use of the VM, such as general-purpose, compute-optimized, memory-optimized, and more. Within that type, you have varying sizes based on the amount of CPU, memory, potential disk, and more. Knowing the types, sizes, and limitations is key to having a successful migration. In this episode of Data Exposed: MVP Edition, let's review some baseline metrics from a SQL Server workload and step through the process to find the correct size virtual machine with Tim Radney and Anna Hoffman.
Watch on Data Exposed
About Tim Radney:
Tim is a Data Platform MVP. He has presented at PASS, SQLintersection, Ignite, SQL Saturdays, user groups, and numerous webinars. Tim runs the Columbus GA SQL Users Group. He’s married with three children and has a passion for gardening.
About MVPs:
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the "bleeding edge" and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products and solutions, to solve real-world problems. MVPs make up a global community of over 4,000 technical experts and community leaders across 90 countries/regions and are driven by their passion, community spirit, and quest for knowledge. Above all and in addition to their amazing technical abilities, MVPs are always willing to help others - that's what sets them apart. Learn more: https://aka.ms/mvpprogram
Resources:
Azure virtual machine sizes naming conventions
M-series
New and Improved SQL on Azure VM deployment and management experience
View/share our latest episodes on Microsoft Docs and YouTube!
