
Explanation:
Box 1: 128.0
-- Connect to database
-- Database data space allocated in MB and database data space allocated unused in MB SELECT SUM(size/128.0) AS DatabaseDataSpaceAllocatedInMB, SUM(size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0) AS DatabaseDataSpaceAllocatedUnusedInMB FROM sys.database_files GROUP BY type_desc HAVING type_desc = 'ROWS' Box 2: sys.database_files Reference:
https://techcommunity.microsoft.com/t5/azure-database-support-blog/how-to-get-azure-sql-database-size/ba-p/369189