By using AWS re:Post, you agree to the AWS re:Post Terms of Use
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

Topics
DatabaseCompute
Tags
Microsoft SQL ServerAmazon EC2Database
Language
English
Sanjeev_K
asked 9 months ago296 views
1 Answer
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
answered 9 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