En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

Capacity planning for SQL server

0

We have a shared server and planning to migrate a few databases to EC2 and the remaining databases to the RDS SQL server. We are using Cloudamize to decide the instance type but it looks like Cloudmize gives the entire server-level reports on how we can determine the RDS and EC2 sizes.

Suppose, if we have 10 databases on SQL server and one application connecting to 6 databases and one application connecting to 4 databases. How we can decide each instance size

Sujets
Base de donnéesCalcul
Balises
Microsoft SQL ServerAmazon EC2Base de données
Langue
English
Sanjeev_K
demandé il y a 10 mois308 vues
1 réponse
1

There are many scripts available on the internet to check the buffer pool, CPU and IO utilization per database. My personal favorites are SQL Server Diagnostic Queries from Glen Berry.

You can use that as a starting point for sizing your instance.

The advantage of cloud and on demand pricing model is that you can scale up or down any time. If you don't get it right, all you have to do is monitor some CloudWatch metrics to see how far your estimates were and adjust accordingly.

AWS
adrian-AWS
répondu il y a 9 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