How to Remediate Amazon EC2 Low-Utilization Checks with Stratusphere™ FinOps
Learn how to tackle AWS EC2 low-utilization checks effectively with Stratusphere™ FinOps. Discover how to optimize your resources and enhance...
Learn how to optimize your Microsoft SQL Server instances on AWS with our consolidation guide. Save on licensing costs and enhance performance now!
When you’re deploying infrastructure to Amazon Web Services (AWS), it’s easy to spin up lots of small, distinct database servers. This could happen because each application team decides to deploy a database server at a separate point in time.
If your application teams are using Microsoft SQL Server, the licensing costs are an additional consideration that affects your monthly AWS invoices. Due to the way that licensing works for Microsoft SQL Server, this fragmented approach to deployment can result in waste for licensing costs.
According to the documentation for AWS Trusted Advisor, licenses for Microsoft SQL Server Standard Edition are sold with a minimum of 4 virtual CPU cores (vCPU). Amazon EC2 allows you to deploy virtual machines with fewer than 4 vCPUs, however. Some of the smaller EC2 instance types only have one or two vCPUs, such as t3.micro, m7a.medium, c7i.large, and others.
If you’re running a licensed copy of Microsoft SQL Server on an EC2 instance with fewer than 4 vCPUs, you are missing out on the full performance utilization of the license.
Here’s an important quote about licensing SQL Server on virtual machines. This quote is taken from the Microsoft SQL Server 2022 licensing guide, where “OSE” refers to an Operating System Environment:
Similar to the Per Core licensing model in physical OSEs, all virtual cores (v-cores) supporting virtual OSEs that are running instances of SQL Server software must be licensed accordingly.
To license individual VMs using the Per Core model, customers must purchase a core subscription license or license with Software Assurance for each v-core (or virtual processor, virtual CPU, virtual thread) allocated to the VM, subject to a four-core license minimum per VM. For licensing purposes, a v-core maps to a hardware thread.
As you can see, a four-core license minimum applies to VMs.
If you have provisioned Amazon EC2 instances, with Microsoft SQL Server Standard or Enterprise installed, and those EC2 instances have fewer than 4 vCPUs, then those would qualify for the consolidation finding.
You can identify opportunities for Microsoft SQL Server consolidation by examining the Findings section in Stratusphere™ FinOps. Stratusphere™ FinOps aggregates cost optimization data across different AWS regions and accounts, into a centralized view. This helps you to easily identify which AWS account these cost savings opportunities can be actioned in.
In the above example, we have two Amazon EC2 instances running SQL Server Standard Edition. One of the EC2 instances has fewer than 4 vCPUs, which is not fully utilizing the licensing cost for SQL Server. The recommended course of action here is to migrate the databases from the server named Orion to Atlas, and retire the Orion server. Before or after the database migration, you can increase the EC2 instance size of the Atlas server, to accommodate the additional load from the databases migrated from Orion.
The first step to remediating this finding is to resize the affected Amazon EC2 instance to an instance type that has at least 4 virtual CPUs. You can search for an appropriate EC2 instance type using the data from the Amazon EC2 On-Demand pricing page.
When you’re consolidating SQL Server instances, there will be some database migration planning work involved. Business applications that write data into databases, such as Microsoft SQL Server, must be configured to connect to their database server endpoint.
Configuration often includes a DNS endpoint, port number, username, password, and a default database. Application configuration is commonly handled with environment variables, configuration files (ie. JSON, YAML, TOML), a managed service like AWS Systems Manager Parameter Store, or using a secrets management solution. If databases are moved between SQL Server hosts, then application configurations will need to be updated, to point applications to the new server, with the appropriate credentials.
Let’s discuss the steps you’ll need to run through in order to plan a database migration project. If you spend more time planning up front, you will help to ensure a smooth and successful migration.
After migrating your databases to a SQL Server with at least 4 vCPUs, you can retire the database servers that have fewer than 4 vCPUs, and save on the additional SQL Server licensing costs.
For a more detailed database migration plan, check out the AWS Prescriptive Guidance Migration strategy for relational databases documentation. AWS also offers a Database Migration Service (DMS) which can help you move databases between SQL servers.
When you’re consolidating Microsoft SQL Server databases, you may want to consider moving them to an Amazon Relational Database Service (RDS) instance. RDS provides additional automated management capabilities over self-managed EC2 instances.
RDS may not be the right solution for you, if you need to install add-ons and external dependencies for SQL Server.
Consolidating Microsoft SQL Server instances is a high-touch effort that will involve effort from cross-functional teams. Due to the high cost for Microsoft SQL Server licensing, it is beneficial to consolidate your databases onto fewer servers, reducing the total number of core licenses that you need to purchase.
While Microsoft SQL Server licensing can be confusing, the simple rule to take away is that you should always have a minimum of 4 virtual CPUs on your EC2 instances running SQL Server Standard or Enterprise instances.
Stratusphere™ helps you to find consolidation opportunities to make the most of your Microsoft SQL Server licensing. Contact our sales team to get started with Stratusphere™ today!
Ready to streamline your Microsoft SQL Server instances and maximize your AWS investment? Contact us today to start your journey toward a more efficient, cost-effective database environment.
Here are some additional resources that can help you learn more about Microsoft SQL Server licensing.
BONUS: Download Your FinOps Guide to Effective Cloud Cost Optimization Here ⤵️
Learn how to tackle AWS EC2 low-utilization checks effectively with Stratusphere™ FinOps. Discover how to optimize your resources and enhance...
Learn how to create a new data source and apply integration with our step-by-step guide. Click now to unlock the full potential of Stratusphere™...
Streamline your AWS costs: eliminate idle load balancers with Stratusphere™ FinOps. Discover how to remediate underutilized AWS Elastic Load...