By using AWS re:Post, you agree to the AWS re:Post Terms of Use

No instance size with 8 vCPUs and 128 GiB RAM for Windows Server and SQL Server on Amazon EC2

0

I was looking through available instance sized for Windows Server and SQL Server on Amazon EC2 and couldn't find one with 8 vCPUs and 128 GiB RAM.

Why is that?

profile picture
asked 2 years ago813 views
2 Answers
0

You could choose an instance size that is a 128gb and change the cpu on launch to match the number of vcpu you require.

https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/instance-specify-cpu-options.html

You can specify these CPU options during instance launch. There is no additional or reduced charge for specifying CPU options. You're charged the same as instances that are launched with default CPU options.

This may not be what you’re looking for cost wise. Have you considered RDS?

profile picture
EXPERT
answered 2 years ago
  • RDS is much more expensive, especially when you need HA with EC2 with FCI compared to RDS Multi AZ with AG:

    RDS for SQL Server db.r6i.4xlarge (16 vCPU 128 GiB RAM) =$4438 x2 for Multi-AZ = 8876$ monthly RDS for SQL Server db.z1d.3xlarge (12 vCPU 96 GiB RAM) =$3902 x2 for Multi-AZ = 7804$ monthly EC2 r6a.4xlarge (16 vCPU 128 GiB RAM) = with Windows 1,361$ + MSSQL BYOL 674$ = 2035$ monthly EC2 x2gd.2xlarge = (missing for Windows+MSSQL BYOL - potentially could cost 1794$ monthly)

    I hope the x2g/x2gd instance classes will be available for SQL Server RDS/EC2 Windows+SQL in the near future.

0

Have you considered x2iedn.xlarge ? It has the memory you are looking for.

SQL Server is much more memory and IO intensive than CPU. Check out a guide we just published https://aws.amazon.com/blogs/modernizing-with-aws/a-guide-to-optimizing-microsoft-licensing-on-aws/ and look for Use the Optimize CPU feature for SQL Server workloads.

AWS
answered 2 years ago
  • x2iedn.xlarge has 128 GiB but only 4 vCPUs (we need 8 vCPUs)

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions