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

Sizing RDS SQL Server for existing SQL Server running on Windows Server

0

I have SQL Server 2016 running on Windows Server 2016 with 4 CPU and 16 GB RAM. We are migrating SQL Server to AWS RDS SQL Server.

I think RDS runs only SQL Server engine and it is lightweight than Windows Server which runs various services required for OS. So I think while choosing RDS instance type e.g. xlarge, 2xlarge etc. we should not look for exactly same CPU and RAM for RDS instance.

I guess RDS large which has 2 CPU and 8 GB RAM will match the SQL server running on Windows server with 4 CPU and 16 GB?

Topics
DatabaseMigration & ModernizationAnalytics
Tags
Microsoft SQL ServerAmazon Relational Database Service
Language
English
rePost-User-Shailesh
asked 2 years ago658 views
1 Answer
2
Accepted Answer

I think before you make sizing of your RDS SQL server instance, you should review the current self built SQL Server 2016 metrics. Though OS of RDS instance indeed optimized, but it still requires some resource. Would suggest after evaluate the current SQL Server metrics, run a test on RDS SQL Server to compare with your current metrics and decide whether it should upsize or downsize the instance.

AWS
Lihu Wu
answered 2 years ago
profile picture
EXPERT
Oleksii Bebych
reviewed 6 months ago
profile picture
EXPERT
Giovanni Lauria
reviewed 8 months ago

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

Relevant content