Capacity planning for SQL server

Question

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

Answer

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](https://glennsqlperformance.com/resources/) 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.

Capacity planning for SQL server

Relevanter Inhalt