Contents tagged with Tables sizes

  • How to find sizes of tables in Acumatica

    Hello everybody,

    today I want to share with you SQL statement that may help you to find sizes of tables occupied by Acumatica. It goes below:

    SELECT 

        t.NAME AS TableName,

        s.Name AS SchemaName,

        p.rows AS RowCounts,

        SUM(a.total_pages) * 8 AS TotalSpaceKB, 

        CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,

        CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00 / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceGB,

        SUM(a.used_pages) * 8 AS UsedSpaceKB, 

        CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB, 

        (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB,

        CAST(ROUND(((SUM( … more