Home

Azure SQL Database - Allocated Space not expanding

%3CLINGO-SUB%20id%3D%22lingo-sub-566739%22%20slang%3D%22en-US%22%3EAzure%20SQL%20Database%20-%20Allocated%20Space%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-566739%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20following%20DB%20which%20the%20Allocated%20Space%20is%20the%20same%20as%20the%20Used%20Space.%26nbsp%3B%20Why%20is%20the%20Allocated%20Space%20not%20growing%3F%3F%26nbsp%3B%20Today%20our%20website%20which%20the%20DB%20is%20for%20started%20to%20get%20SQL%20errors%20when%20saving%20content%2C%20so%20I%20am%20presuming%20this%20is%20the%20reason%20as%20there%20is%20no%20more%20room%20in%20the%20DB.%26nbsp%3B%20Can%20anyone%20help%2C%20please%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113294iD2FBE500B4454A33%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22DBSettings.jpg%22%20title%3D%22DBSettings.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F113293i2B4B36D83D62E2EE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22DBStorage.jpg%22%20title%3D%22DBStorage.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-566739%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-662983%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Database%20-%20Allocated%20Space%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-662983%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20chance%20you%20could%20include%20the%20SQL%20errors%20your%20are%20getting%3F%20Since%20you%20are%20on%20the%20lowest%20tier%20of%20SQL%20database%20I%20am%20wondering%20if%20you%20are%20hitting%20performance%20thresholds%20versus%20the%20limitation%20on%20space.%20It%20could%20definitely%20aid%20to%20pinpointing%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20do%20feel%20that%20it%20is%20still%20related%20to%20space%20you%20can%20see%20the%20following%20link.%20You%20will%20see%20the%20SQL%20query's%20to%20query%20your%20particular%20database%20to%20get%20a%20real-time%20report%20on%20space%20used%2C%20space%20allocated%2C%20and%20max%20size.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-file-space-management%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-file-space-management%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EResource%20limits%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-dtu-resource-limits-single-databases%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-dtu-resource-limits-single-databases%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20attach%20or%20include%20the%20logs%20I%20would%20be%20happy%20to%20take%20a%20look!%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2552%22%20target%3D%22_blank%22%3E%40Tanya%20Denton%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-682122%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Database%20-%20Allocated%20Space%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-682122%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F183000%22%20target%3D%22_blank%22%3E%40Bryan%20Haslip%3C%2FA%3E%26nbsp%3BI%20am%20so%20sorry%20for%20the%20delay%20in%20responding%2C%20had%20a%20few%20weeks%20leave!%26nbsp%3B%20The%20issue%20seems%20to%20have%20resolved%20itself%20as%20all%20is%20showing%20correctly%20now%20-%20we%20must%20have%20had%20a%20blip!%26nbsp%3B%20Thanks%20so%20much%20for%20responding%20to%20my%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-682135%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Database%20-%20Allocated%20Space%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-682135%22%20slang%3D%22en-US%22%3E%3CP%3ENo%20worries%20at%20all!%20Glad%20to%20hear%20it%20is%20resolved.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2552%22%20target%3D%22_blank%22%3E%40Tanya%20Denton%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-836027%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Database%20-%20Allocated%20Space%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-836027%22%20slang%3D%22en-US%22%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2487%22%20target%3D%22_blank%22%3E%40Tanya%20Denton%3C%2FA%3E%2C%3CBR%20%2F%3ECan%20you%20please%20help%20us%3F%3CBR%20%2F%3EWe%20are%20facing%20the%20same%20issue.%20(Allocated%20Space%20is%20not%20growing)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-836171%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Database%20-%20Allocated%20Space%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-836171%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403058%22%20target%3D%22_blank%22%3E%40Coeffyteam%3C%2FA%3E%26nbsp%3BTo%20be%20honest%20i%20did%20not%20do%20anything.%26nbsp%3B%20When%20i%20came%20back%20from%20leave%20it%20had%20sorted%20itself%20out.%26nbsp%3B%20Sorry%20can't%20give%20you%20any%20more%20info%20on%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-840655%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Database%20-%20Allocated%20Space%20not%20expanding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-840655%22%20slang%3D%22en-US%22%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2487%22%20target%3D%22_blank%22%3E%40Tanya%20Denton%3C%2FA%3E%2C%3CBR%20%2F%3Eok%20thanks%3C%2FLINGO-BODY%3E
Tanya Denton
Regular Contributor

I have the following DB which the Allocated Space is the same as the Used Space.  Why is the Allocated Space not growing??  Today our website which the DB is for started to get SQL errors when saving content, so I am presuming this is the reason as there is no more room in the DB.  Can anyone help, please?

DBSettings.jpg

 

DBStorage.jpg

 

7 Replies

Any chance you could include the SQL errors your are getting? Since you are on the lowest tier of SQL database I am wondering if you are hitting performance thresholds versus the limitation on space. It could definitely aid to pinpointing the problem.

 

If you do feel that it is still related to space you can see the following link. You will see the SQL query's to query your particular database to get a real-time report on space used, space allocated, and max size. 

 

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-file-space-management

 

Resource limits - https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dtu-resource-limits-single-database...

 

If you attach or include the logs I would be happy to take a look!

@Tanya Denton 

@Bryan Haslip I am so sorry for the delay in responding, had a few weeks leave!  The issue seems to have resolved itself as all is showing correctly now - we must have had a blip!  Thanks so much for responding to my issue.

No worries at all! Glad to hear it is resolved. @Tanya Denton 

Hello @Tanya Denton,
Can you please help us?
We are facing the same issue. (Allocated Space is not growing)

@Coeffyteam To be honest i did not do anything.  When i came back from leave it had sorted itself out.  Sorry can't give you any more info on this.

I am also facing the same issue and as I read from above, it seems like someone from other planet entered into Azure data center and resolved it.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies