Checking your DB Size

This guide details how you can check your On-Premise Halo database size.

Please run the below query directly on your Halo database:

SELECT 
    s.name AS SchemaName,
    t.name AS TableName,
    SUM(p.rows) AS RowCounts,
    -- Total space in MB and GB
    CAST(SUM(a.total_pages) * 8.0 / 1024 AS DECIMAL(10,2)) AS TotalSpaceMB,
    CAST(SUM(a.total_pages) * 8.0 / (1024 * 1024) AS DECIMAL(10,2)) AS TotalSpaceGB,
    -- Used space in MB and GB
    CAST(SUM(a.used_pages) * 8.0 / 1024 AS DECIMAL(10,2)) AS UsedSpaceMB,
    CAST(SUM(a.used_pages) * 8.0 / (1024 * 1024) AS DECIMAL(10,2)) AS UsedSpaceGB,
    -- Unused space in MB and GB
    CAST((SUM(a.total_pages) - SUM(a.used_pages)) * 8.0 / 1024 AS DECIMAL(10,2)) AS UnusedSpaceMB,
    CAST((SUM(a.total_pages) - SUM(a.used_pages)) * 8.0 / (1024 * 1024) AS DECIMAL(10,2)) AS UnusedSpaceGB
FROM 
    sys.tables t
INNER JOIN 
    sys.schemas s ON t.schema_id = s.schema_id
INNER JOIN 
    sys.partitions p ON t.object_id = p.object_id
INNER JOIN 
    sys.allocation_units a ON p.partition_id = a.container_id
WHERE 
    t.is_ms_shipped = 0
GROUP BY 
    s.name, t.name
ORDER BY 
    TotalSpaceMB DESC;