What Happens When I reach the allocated level (1 GB or 10 GB) in SQL Azure?

  • Article

SQL Azure Many times I am asked “When I reach the allocated level (1 GB or 10 GB) in SQL Azure, what happens?”

The answer: only SELECTs and DELETEs will be supported. UPDATEs and INSERTs will throw an error.

Any workaround? yes.

Because of above size constraints, one of the recommendations is to partition the data across databases. Creating multiple databases will allow you take maximum advantage of the computing power of multiple nodes. The biggest value in the Azure model is the elasticity of being able to create as many databases as you need, when your demand peaks and delete/drop the databases as your demand subsides.