Tempdb Has Reached Its Size Quota: How To Increase Size Quota For Tempdb On Azure Sql

We are getting an error while loading data from one table to another. We do some monthly/quarterly roll ups on the first table data which is inserted into another table The source

Solution 1:

SQLAzure enforces different limits,some are applicable irrespective of tiers,some limits may be higher depending on your service tier.Below is the way Azure handles those limits

Enforcement of limits

Resources other than CPU, Memory, Log I/O, and Data I/O are enforced by denying new requests when limits are reached. When a database reaches the configured maximum size limit, inserts and updates that increase data size fail, while selects and deletes continue to work. Clients receive an error message depending on the limit that has been reached.

so this answers your question on whether we can increase size of TEMPDB

Below are the limits for TEMPDB

This Page Azure SQL Database Resource Limits contains entire Limits in detail, i will try to add all the details when time permits or when i find the Github page ,so that link rot can be avoided