# SQL Server on EC2 Instances Below the 4-vCPU License Minimum Canonical: https://www.pointfive.co/efficiency-hub/inefficiencies/sql-server-on-ec2-instances-below-the-4-vcpu-license-minimum Under Microsoft's SQL Server core licensing rules, each server running SQL Server must be licensed for a minimum of four cores, so an EC2 instance with... By: PointFive Updated: 2026-09-28 [Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) The short version Under Microsoft's SQL Server core licensing rules, each server running SQL Server must be licensed for a minimum of four cores, so an EC2 instance with one or two vCPUs running SQL Server under bring-your-own-license still needs four core licenses. PointFive Research Cloud cost research at PointFive AWS service [AWS EC2](https://www.pointfive.co/efficiency-hub/cloud-services/aws-ec2) Category [Databases](https://www.pointfive.co/efficiency-hub/service-category/databases) Reference CER-0347 Type Inefficient Configuration ## Explanation Why the waste happens and who it affects. AWS Trusted Advisor applies the same rule to SQL Server on EC2, stating that you pay for 4 vCPU licenses even if an instance has only 1 or 2 vCPUs, and AWS Prescriptive Guidance also recommends consolidating many small license-included SQL Server instances. The pattern is common where each application, customer or environment gets its own small SQL Server instance for isolation, and in development, test and staging fleets built from the same small template. Each instance is cheap on compute, but the license floor means a fleet of 2-vCPU SQL Server instances licenses twice as many vCPUs as it runs. AWS Prescriptive Guidance shows the effect with four m6i.large SQL Server Standard servers: consolidating them onto one m6i.2xlarge keeps the same total vCPUs and memory but halves the vCPUs to license, from 16 to 8 (using Microsoft's public Standard pricing, $31,560 versus $15,780). ## Billing model The pricing dimensions that drive this cost. Four-core license minimum SQL Server core licenses are sold in two-core packs with a minimum of four cores per server, so an instance with fewer vCPUs is licensed as four Bring your own license Each small instance consumes four core licenses from the customer's SQL Server license pool License-included instances The SQL Server license is part of the EC2 hourly rate for the SQL Server AMI, and AWS guidance still recommends consolidating many small license-included instances ## How to detect 4 checks to find it in your estate. - Review the Trusted Advisor cost optimization check Amazon EC2 instances consolidation for Microsoft SQL Server (check ID Qsdfp3A4L2), which turns yellow for any instance running SQL Server with fewer than 4 vCPUs and reports the vCPU count, minimum vCPU and SQL Server edition - Inventory SQL Server instances by vCPU count, edition and licensing model, and count how many have 1 or 2 vCPUs - Collect CPU, memory, network and storage IOPS and throughput metrics over a long period for the small instances, including when their peaks occur, to see which ones could share a server - Group small instances by environment, edition and compliance boundary to find realistic consolidation sets, such as non-production databases ## How to fix 5 ways to remove the waste. - Consolidate several small SQL Server workloads onto one instance with at least four vCPUs, either as multiple databases in one SQL Server instance or as multiple named SQL Server instances on one EC2 instance - When stacking named instances, give each a unique name and port, run the SQL Server Browser service, and set max server memory for each so their total leaves memory for the operating system - Migrate databases with native backup and restore or AWS DMS, then retire the small instances - Prefer consolidating low-usage and non-production databases; AWS does not recommend putting large production databases on a single server - For databases that are too small to justify SQL Server licensing at all, evaluate a free edition (Express within its limits, or Developer for non-production) or another engine ## Documentation Vendor references for pricing and configuration. - [Cost optimization - AWS Support docs.aws.amazon.com](https://docs.aws.amazon.com/awssupport/latest/user/cost-optimization-checks.html) - [Consolidate instances docs.aws.amazon.com](https://docs.aws.amazon.com/prescriptive-guidance/latest/optimize-costs-microsoft-workloads/consolidate-instances.html) - [Review Trusted Advisor recommendations for SQL Server workloads docs.aws.amazon.com](https://docs.aws.amazon.com/prescriptive-guidance/latest/optimize-costs-microsoft-workloads/sql-server-trusted-advisor.html) - [Compare SQL Server editions docs.aws.amazon.com](https://docs.aws.amazon.com/prescriptive-guidance/latest/optimize-costs-microsoft-workloads/sql-server-editions.html) ## Related inefficiencies [Browse the library](https://www.pointfive.co/efficiency-hub) - AWS EC2 CER-0346 ### [SQL Server Enterprise Edition on EC2 Without Enterprise Feature Use](https://www.pointfive.co/efficiency-hub/inefficiencies/sql-server-enterprise-edition-on-ec2-without-enterprise-feature-use) SQL Server on EC2 is frequently deployed as Enterprise edition by default: it is picked from an AMI list, inherited from an on-premises build, or chosen to avoid future limits. Many of these databases never use an Enterprise-only feature.... Databases - AWS EC2 CER-0348 ### [SQL Server Instances Exceeding Edition vCPU Limits on EC2](https://www.pointfive.co/efficiency-hub/inefficiencies/sql-server-instances-exceeding-edition-vcpu-limits-on-ec2) SQL Server Standard and Web editions cap how much compute a single SQL Server instance can use. Standard is limited to the lesser of 4 sockets or 24 cores, which AWS expresses as 48 vCPUs on EC2, and Web is limited to the lesser of 4... Databases - AWS EC2 CER-0327 ### [Spot Instance Overreliance Without Effective Cost-Per-Performance Analysis](https://www.pointfive.co/efficiency-hub/inefficiencies/spot-instance-overreliance-without-cost-per-performance-analysis) Organizations frequently pursue aggressive Spot Instance adoption based on headline discount percentages - up to 90% off On-Demand pricing - without evaluating the effective cost per unit of work completed. While Spot pricing can deliver... Compute --- Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.