BL0B_EATER (8/14/2015)
Grant Fritchey (8/13/2015)
Eric M Russell (8/13/2015)
SQL Azure should be technically up to the task. However, my understanding is that you get billed based on network transfer fees. How many GB total of data do you anticipate sitting in the cloud a year from now, and how many GB of data transfer monthly?But isn't the suggested plan for the warehouse to be in Azure too? Then the costs are just storage, not data transfer.
Isn't there "compute" cost too? I only say this because I was running some intensive queries up there and noticed a nice bill a few weeks later...
You pay for the service level you set. You can max that service level without additional charges. That's been my experience and the way it was explained to me.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning