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

Question

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?

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.

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

Conteúdo relevante