There's a way to calculate how many DTU's a given regular server outputs, but i need the other way around!
I'm planning on leaving the azure environment, and I need a way to measure how much CPU/Memory I should use on my RDS.
Right now I know I consume around 100 DTUs…
so, roughly speaking, which machine is capable of such output?
Best Answer
This answer from SO seems to indicate it may intentionally be clouded in mystery... which makes perfect sense if you're Microsoft and very much want people to move into the cloud instead of hosting their own architecture. The cloud is where they get a much bigger slice of the $ pie, after all!
You could always default back to classic recommendations on specs based on nature of workload, size, etc. People were spec'ing VMs long before DTUs :)
Here are a few resources in this vein, though there are many more and none are all-inclusive:
Brent Ozar also offers training in this area if you really need to hit the nail on the head with this server transition (I am not affiliated with Brent Ozar Unlimited in any way).
At the end of the day, you'll probably have to do some tuning either way, so I'd start small and work my way up in a test environment. You know your application(s) and workload(s) best so you need to figure out what features and specs are going to get you to your desired state.