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


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?

1 Answer
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.

Lihu Wu
answered 2 years ago
profile picture
reviewed 2 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