Deep Dive: Azure SQL Virtual Machine Sizing | Data Exposed Live

%3CLINGO-SUB%20id%3D%22lingo-sub-2200330%22%20slang%3D%22en-US%22%3EDeep%20Dive%3A%20Azure%20SQL%20Virtual%20Machine%20Sizing%20%7C%20Data%20Exposed%20Live%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2200330%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20style%3D%22font-size%3A%2011.0pt%3B%20font-family%3A%20'Calibri'%2Csans-serif%3B%20mso-fareast-font-family%3A%20Calibri%3B%20mso-fareast-theme-font%3A%20minor-latin%3B%20mso-ansi-language%3A%20EN-US%3B%20mso-fareast-language%3A%20EN-US%3B%20mso-bidi-language%3A%20AR-SA%3B%22%3ETypically%2C%20you%20choose%20a%20VM%20when%20your%20application%20requires%20more%20control%20over%20the%20computing%20environment%20than%20the%20other%20platform-as-a-service%20options%20offer.%20This%20can%20be%20due%20to%20vendor%20requirements%2C%20familiarity%20with%20virtualization%2C%20ease%20of%20migration%20and%20other%20scenarios.%20When%20selecting%20a%20virtual%20machine%20to%20host%20your%20SQL%20Server%20workload%20in%20Azure%2C%20you%20need%20to%20choose%20a%20virtual%20machine%20size%20that%20provides%20optimal%20performance%20and%20fits%20your%20organization%E2%80%99s%20budget.%20In%20this%20session%20with%20Pam%20Lahoud%2C%20David%20Pless%2C%20and%20Amit%20Banerjee%2C%20we%20will%20cover%20topics%20such%20as%20the%20different%20virtual%20machine%20types%20that%20are%20most%20appropriate%20for%20SQL%20Server%20workloads%2C%20optimal%20memory-to-core%20ratios%20for%20various%20workload%20types%2C%20and%20features%20unique%20to%20Azure%20such%20as%20write%20acceleration%20that%20can%20help%20boost%20your%20performance%20without%20breaking%20the%20bank.%20We%20will%20also%20cover%20the%20Azure%20Virtual%20Machine%20naming%20conventions%20and%20how%20you%20can%20quickly%20identify%20the%20capabilities%20of%20a%20given%20machine%20from%20the%20virtual%20machine%20series%20name.%20We%20will%20close%20out%20the%20discussion%20with%20a%20review%20of%20virtual%20machine%20disks%20and%20storage%20limits%20that%20will%20be%20a%20precursor%20to%20the%20next%20deep%20dive%20on%20Azure%20SQL%20VM%20storage.%20To%20check%20out%20even%20more%20Data%20Exposed%20Live%20episodes%2C%20see%20our%20playlist%3A%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fdataexposedlive%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fdataexposedlive%3C%2FA%3E%20Subscribe%20to%20our%20YouTube%20channel%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fmsazuresqlyt%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fmsazuresqlyt%3C%2FA%3E%20Follow%20us%20on%20Twitter%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fazuresqltw%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fazuresqltw%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2200330%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20SQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Exposed%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EInfrastructure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProductivity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

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, David Pless, and Amit Banerjee, 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. To check out even more Data Exposed Live episodes, see our playlist: https://aka.ms/dataexposedlive Subscribe to our YouTube channel: https://aka.ms/msazuresqlyt Follow us on Twitter: https://aka.ms/azuresqltw

1 Reply
Invaluable Information. Thank you!

Session Resources