Right Size EC2 Instance

0

Hi,

I have a physical on-premises server with 2 Intel Xeon Gold processors, running SQL Server 2019. As per the specifications, the Xeon processor has 20 cores and 40 Thread. I want to now migrate SQL Server to AWS EC2 and looking for right size EC2 instance. The Database is used quite extensively with 70% CPU utilisation in every 5 mins.

Could someone please suggest the right instance type for EC2?

已提问 2 年前344 查看次数
1 回答
0

Hi - Thanks for reaching out. I think below resources should help a lot

  1. https://docs.aws.amazon.com/prescriptive-guidance/latest/sql-server-ec2-ha-dr/single-node.html#instance-type - this does talks about some of the proposed instance types
  2. https://docs.aws.amazon.com/prescriptive-guidance/latest/sql-server-ec2-best-practices/welcome.html - this should be looked into example Avoid CPU core mismatches etc.

Thanks

profile pictureAWS
专家
已回答 2 年前
  • Thanks for the response.

    I'm bit not clear on how many vCPUs should be required for this. The Intel Xeon Gold on-remises processor has 20 cores. And there are two such processors on that host. So total of 40 cores.

    So should I select an instance with at least 80 vCPUs and 40 cores? Like an r5.24xlarge instance with 48 cores and 96 vCPUs?

  • One of the benefits of the cloud is agility - when you purchased those Xeon Gold processors, you most likely had to use them until your organization went through another refresh cycle. With AWS, you can pick an instance (such as the R5.24xlarge), get a performance profile of your workload, and, if the instance is oversized or undersized, easily change what you're using. I'd look at a newer generation (i.e. R6i) if your workload is memory intensive. If your workload is compute intensive, you can check out the C series. Here's the link to how to change the instance type: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ec2-instance-resize.html

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则