SQL Azure: What Will Happen If Size of My SQL Azure Get 5Gb

Upgrading SQL Azure database size

See my answer on this other SO question. In a nutshell, you modify db size with T-SQL, such as:

ALTER DATABASE MyDatabase MODIFY (EDITION='WEB', MAXSIZE=5GB)

How to Resize a SQL Azure Database

I answered a similar question here. It should be as simple as running an ALTER DATABASE command:

ALTER DATABASE MyDatabase MODIFY (EDITION='WEB', MAXSIZE=1GB)

Just keep this in mind: As long as your usage is <= 1GB, you'll be billed at the 1GB rate. Billing is monthly but amortized daily. So you actually don't need to reduce your max size unless you're relying on SQL Azure to prevent you from growing beyond 1GB.

EDIT: As of Feb. 2012, there's a new 100MB pricing tier (at $4.99, vs. $9.99 at 1GB). While you can't set MAXSIZE to 100MB, your monthly cost will drop if you stay under 100MB. See this blog post for more details.

Azure will be free with 5GB bandwidth and no database?

If you stick to the Free tier, you won't have any additional charges. Azure lists the details here.

The pricing calculator shows the 5GB bandwith as free since its based on monthly charge. In the link you can see that the free tier offers outbound data transfer at 'up to 165MB per day' which works out to 5GB if you were to run at that everyday for a month.

Azure DTUs for a medium size application

it seems SQL server Express Edition has performance issues

This is not correct.There are certain limitations like 10GB size,one core CPU and some features are disabled ..

I am initially assuming 100 DTUs is good enough but looking for some advice on someone who has dealt with this before.

I would go with the advice of DTU calculator,but if you want to go with 100 DTU's,i recommend going with it ,but consistently evaluate performance..

Below query can provide you DTU metrics in your instance and if any one of the metrics is consistently over 90% over a period of time,i would try to tune that metric and finally upgrade to new tier,if i am not successfull

DTU query

SELECT start_time, end_time,      
  (SELECT Max(v)      
   FROM (VALUES (avg_cpu_percent), (avg_physical_data_read_percent), (avg_log_write_percent)) AS value(v)) AS [avg_DTU_percent]    
FROM sys.resource_stats   
WHERE database_name = '<your db name>'   
ORDER BY end_time DESC;

---

Related Topics