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
已提問 1 年前檢視次數 487 次
2 個答案
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
專家
已回答 1 年前
  • 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
Rafet
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南