Hi,
When you decide to move to Azure you'll want to implement some auto-scalling logic in order to be the most
cost effective you can on the cloud.
You'll want to add more instances when your app has more requests and turn them down when there's less requests.
I suggest you take a look to Windows Azure Autoscaling Application Block (WASABi) in order to implement that kind of logic.
You start with minimum roles and then grow as needed.
If you found this post useful, Please "Mark as Answer" or "Vote as Helpful". Best Regards.