question

RayWages-2990 avatar image
0 Votes"
RayWages-2990 asked AlbertoMorillo commented

Azure SQL DB size

Azure SQL DB shows max size of 30 GB with only about 4 GB in use for the DB size in Azure portal. Using SSMS, the properties of the DB shows 30 GB total size and a DB of about 4 GB again. However, the DB stopped updating and was acting like it ran out of space. The above was checked and showed the same information, but not if you query the DB. When you query it the DB shows only a few KB available above the 4 GB and that appears to be the problem. Why the discrepancy in reporting space available. I see no way to correct this. Is this a bug with the system? Currently down since the Friday, the17th.

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

This article gives you some reasons why calculating the database size using T-SQL and sys.database_files DMV is the more accurate way to know the size of the database. There are multiple ways to calculating the size of the database as exposed on the article.

Users have also documented this discrepancy between Portal and T-SQL on the Web. Please read this example.

Hope this helps.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RayWages-2990 avatar image
0 Votes"
RayWages-2990 answered AlbertoMorillo commented

Thanks! Accepted.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for visiting QA forums! Have a great day!

0 Votes 0 ·