Score:0

Calculating IOPS in a SQL Server EC2 - RDS migration

us flag

I'm evaluating costs for a possible migration of a SQL Server that is currently running on Amazon EC2 to Amazon RDS. On the EC2 instance I have six volumes, described as follows:

type size IOPS
gp2 100 GB 300
io1 250 GB 1700
io1 550 GB 1700
gp2 100 GB 300
io1 700 GB 1700
io1 1750 GB 4700

I can't specify the same six volumes on the RDS price calculator. I get just one field for the storage. Regarding the space, easy-peasy, just sum it. But, how about the IOPS? Should I just opt for the largest (4700 in this case), or should I sum all of them?

joeqwerty avatar
cv flag
Take a look at the following articles to calculate your DTU's and translate that to IOPS and see if that gets you what you need. - https://dtucalculator.azurewebsites.net - https://docs.microsoft.com/en-gb/azure/azure-sql/database/service-tiers-dtu
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.