Forum Discussion
Azure SQL Database - Allocated Space not expanding
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...
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-databases
If you attach or include the logs I would be happy to take a look!
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.
- 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.
No worries at all! Glad to hear it is resolved. Tanya Denton
