Constrained vCPU sizes for database workloads

Applies to: ✔️ Linux VMs ✔️ Windows VMs ✔️ Flexible scale sets ✔️ Uniform scale sets

Tip

Try the Virtual Machine selector tool to find other sizes that best fit your workload.

Some database workloads require high memory, storage, and I/O bandwidth, but don't benefit from a high number of cores. Products designed for these workloads are often licensed on a per-CPU-core basis. This licensing system means that a VM size with otherwise ideal specifications but an excessive vCPU count can cause a substantial increase in licensing costs. To help manage your costs, Azure offers predefined VM sizes with a lowered vCPU count to help to reduce the cost of software licensing, while maintaining the same memory, storage, and I/O bandwidth.

The original size's available vCPU count can be reduced to either one half or one quarter of the original size specification. These new VM sizes have a suffix that specifies the number of available vCPUs to make them easier for you to identify. Learn more about VM size naming conventions.

Example workload

The licensing fees charged for SQL Server are based on the available vCPU count. Third party products should count the available vCPUs and report it as the amount to be used and licensed. This constraint results in a 50% to 75% increase in the ratio of the VM specs to available (billable) vCPUs while maintaining the benefits of the original VM size's specifications.

Specification comparison

The Standard_E32s_v5 VM size comes with 32 vCPUs, 256 GiB of RAM, 32 disks, and 80,000 IOPs of I/O bandwidth. The pre-defined Standard_E32-16s_v5 and Standard_E32-8s_v5 VM sizes comes with 16 and 8 active vCPUs respectively, while maintaining the memory, storage, and I/O bandwidth specifications of the Standard_E32s_v5.

Size type Size name Disabled vCPUs Active vCPUs Memory, Storage, I/O
Base (Original) Standard_E32s_v5 0 32 256 GiB, 32 Disks, 80,000 IOPs
Constrained Standard_E32-16s_v5 16 16 256 GiB, 32 Disks, 80,000 IOPs
Constrained Standard_E32-8s_v5 24 8 256 GiB, 32 Disks, 80,000 IOPs

Note

Disabled vCPUs are not available for use by the VM. If your VM has multiple workloads assigned to it then it may require more vCPUs. If possible, relocate secondary tasks to another virtual machine to avoid increased licensing costs.

Pricing

At this time, the VM pricing, remains the same as the original size. For more information, see Azure VM sizes for more cost-effective database workloads.

List of available sizes with constrained vCPUs

Size name Active vCPUs Base size
Standard_M8-2ms 2 M8ms
Standard_M8-4ms 4 M8ms
Standard_M16-4ms 4 M16ms
Standard_M16-8ms 8 M16ms
Standard_M32-8ms 8 M32ms
Standard_M32-16ms 16 M32ms
Standard_M64-32ms 32 M64ms
Standard_M64-16ms 16 M64ms
Standard_M128-64ms 64 M128ms
Standard_M128-32ms 32 M128ms
Standard_M416-208s_v2 208 M416s_v2
Standard_M416-208ms_v2 208 M416ms_v2

Other standard sizes

Next steps

Learn more about how Azure compute units (ACU) can help you compare compute performance across Azure SKUs.