Selecting the right Azure VM for SQL

When looking for the right VM for SQL we need to look at a lot of factors, but mainly these four factors

  • Throughput of VM (Cached and Uncached)
  • Cores Available
  • VM Memory GN
  • Cost per month (compute and SQL license)

This can be difficult to do as may current tools to pick a VM don’t easily allow you to compare say throughput limits. and cost at the same time.

To make this easier I created a sample PBIX that reads in Azure VM Stats and pricing using Powershell and allows you to compare the VM Range.

Sample Report Below

https://app.powerbi.com/view?r=eyJrIjoiNGMyYTVhNjMtNDc4Zi00MzgzLWJiMGMtM2QwOTRlNDhjMDg0IiwidCI6ImQ4Y2E5OTJhLTVmYmUtNDBiMi05YjhiLTg0NGUxOThjNGM5NCIsImMiOjh9&pageName=ReportSection

You can download this report and the Powershell code from GitHub on link below
https://github.com/ProdataSQL/Demos/tree/main/IaaS/AzVmPricing


Warning:

This is based on North Europe and EUR consumption prices (not EA or reservations) and as of 07/03/2022 so may get out of date!

Leave a Reply