En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
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?

Sujets
Base de donnéesMigration et modernisationAnalytique
Balises
Microsoft SQL ServerAmazon Relational Database Service
Langue
English
rePost-User-Shailesh
demandé il y a 2 ans482 vues
1 réponse
1
Réponse acceptée

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
répondu il y a 2 ans
profile picture
EXPERT
Giovanni Lauria
vérifié il y a un mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents