CODEWITHSUNDEEP
azureazure-sql-database
odyth
odyth

Reputation: 4336

Azure SQL Server database price

I signed up for Windows Azure and I was given a 1gb database as part of my trial. So my max size is 1gb and once I reach that size inserts will start to fail until I update the max size to 10gb.

Now my question is, if I update the max size now to 10gb and I only use 400mb, will I still be charged that the 1gb rate? I think the answer is yes and if it is they why don't I just set the max size at 50gb so an insert never fails?

Upvotes: 1

Views: 875

Answers (1)

David Makogon
David Makogon

Reputation: 71120

There are two editions: Web (1GB and 5GB) and Business (10GB through 50GB in 10GB increments). If you stay with a Web edition and go over the 1GB threshold on any given day, you'll be charged at the 5GB rate for that day. This is amortized daily over the month. So it's entirely possible you'll accrue costs just a little bit over the 1GB rate (if you upgrade to the 5GB Web Edition).

Moving to the Business edition, the lowest tier is 10GB, so that would be your baseline rate. Again, it's amortized daily.

If you want to set Web edition to 5GB (or Business edition to 50GB), you're going to avoid insert fails, as you pointed out. The tiers are going to help you when trying to manage cost.

See this MSDN blog post detailing the tiers, along with information on the ALTER DATABASE command.

Upvotes: 4

Related Questions