Right Size EC2 Instance



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?

feita há 2 anos338 visualizações
1 Resposta

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.


profile pictureAWS
respondido há 2 anos
  • 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

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas