Question
Azure SQL Database automatic growth near configured maximum size
Neel Finch
0 reputation · 19 Feb 2020, 05:54 UTC
69.9K views1
Loading…
0 reputation · 19 Feb 2020, 05:54 UTC
This question clarifies how Azure SQL Database handles automatic storage growth as a vCore-based General Purpose database approaches its configured maximum size. Service limits indicate that automatic growth occurs in 10 GB increments for vCore databases under General Purpose and Business Critical, while the tier maximum is 4 TB per database. It is unclear whether a growth increment can exceed the configured maximum size, or whether the database stops growing once the current size reaches the configured limit even if space remains below the tier cap.
The purchasing model and configured maximum size must be interpreted separately from the absolute tier limit. Operators need to know whether automatic growth pauses at the configured maximum or attempts the next 10 GB increment and fails when the limit is reached.
Does automatic growth stop at the configured maximum size, or can the final increment temporarily exceed it before enforcement? Is the configured maximum size the authoritative boundary for growth, or does the 4 TB tier cap govern behavior independently?
35775 reputation · 19 Feb 2020, 14:41 UTC
Automatic storage growth in an Azure SQL Database, particularly for vCore-based General Purpose tiers, operates strictly against the configured maximum size. Growth increments are typically 10 GB, but this increment will not cause the database size to exceed the established configured maximum.
The configured maximum size serves as the authoritative ceiling for the database instance. The absolute tier maximum (e.g., 4 TB) is a service-level constraint for the entire tier, not a dynamic limit that overrides the per-database configuration. Therefore, growth pauses exactly when the configured limit is met, rather than attempting an increment that would breach it.
To confirm if the growth mechanism is functioning as expected under load, please confirm the specific service tier (General Purpose or Business Critical) currently assigned to the database.
Use comments to ask for clarification. Post a solution as an answer.
No question comments on this page.
azuresqldatabase