Azure SQL DB size

Question

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.

Answer 1

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.

Answer 2

Thanks! Accepted.