Choosing right RDS Instance type for SQL Server

0

Hello, We have around 10 databases and planning to migrate to RDS SQL Server(2 RDS). currently we have 4 CPU and 16 GB RAM. How to decide the right sizing for RDS instance . do we have any queries to capture the SQL Server metircs.

Thanks

2개 답변
2

Hi,

To right-size while optimizing your costs, I would suggest 2 complementary options:

  1. separate each of your distinct databases in its own RDS instance. This way you will be able to optimize the full setup (sizing, storage, backup, HA) individually to best match the needs without having to decide based on the most demanding of your 4 dbs.
  2. leverage auto-scaling for both storage: https://aws.amazon.com/about-aws/whats-new/2019/06/rds-storage-auto-scaling/ to avoid under- or overprovisionning until you know well capacity that you need if you eventually want to shift to a static configuration. It happens without downtime. For compute scaling: you have to choose between 2 options: horizontal or vertical scaling depending on your use case. This blog will help you to choose: https://aws.amazon.com/blogs/database/scaling-your-amazon-rds-instance-vertically-and-horizontally/

Best,

Didier

profile pictureAWS
전문가
답변함 5달 전
  • Thanks Didier , We are more focus on instance type (db.m5.large etc)

1

Hello,

You can start by matching your existing database servers' vCPU and memory configuration.Then if you need you can upsize your instance size as per your need. It is also good to overprovision by 10-20% initially to allow for future growth

Below are a few links you can refer to that will help you in choosing the right size for your RDS -

https://docs.aws.amazon.com/whitepapers/latest/cost-optimization-right-sizing/tips-for-right-sizing-your-workloads.html

https://aws.amazon.com/blogs/database/capture-and-tune-resource-utilization-metrics-for-amazon-rds-for-sql-server/

Thanks

답변함 5달 전
  • Thanks for sharing your inputs, if we have dedicated server than we can follow above but if , we have shared databases server with mutiple applications, how to idenfity which database is using more resources , do we have any helps scripts from AWS. Thanks

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인