Contents tagged with Tables sizes

• How to find sizes of tables in Acumatica

  Friday, February 01, 2019 2:25:25 PM

  No Comments

  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