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.